10
I have this code here...
For Each cell In worksheet.Cells(8, 2, lastRow, lastCol)
Select Case "What Goes Here"
End Select
Next
I want to verify the column that the current cell is in. I can use...
cell.Address
but that returns a string with both the column letter and row. Would there be another way of getting maybe just the index or letter only of the column or would I just have to do something like....
If cell.Address.Contains("A")