Hi. Is there a VBA function which converts "H" to 8 and "AC" to 29, and in general, given any column letter label, returns the number of that column?
I'm thinking
Worksheets.("Sheet1").Columns("H").Index
but of course there's no such property. Please help. Thank you.
I'm thinking
Worksheets.("Sheet1").Columns("H").Index
but of course there's no such property. Please help. Thank you.