On May 8, 10:27*am, Gord Dibben wrote:
Can you "more concise" this one?

Function GetColNum(myColumn As String) As Long
* * GetColNum = Columns(myColumn & ":" & myColumn).Column
End Function

One way:

GetColNum = Range(myColumn & 1).Column