Column Number from Column Letter

[Guest]

I have the column letter of a cell and I need the column number. I know this
must be simple but I cannot figure out how to do it.

 

[Jon Peltier]

In a cell:
=COLUMN(A1)

In VBA:
iColNum = Worksheets("Sheet1").Range("A1").Column

- Jon

 

[Guest]

Try:-

=COLUMN(E1)

Would return 5.

Mike

 

[Guest]

Robert,

One way is to use the Column property of the Range object. For example, to
determine the column number of the column "AY",

Sub test()
Dim iColumn As Integer
iColumn = Range("AY1").Column
End Sub

 

[Guest]

Function ColLetterToNumber(Letter As String) As Long
ColLetterToNumber = Columns(Letter).Column
End Function

 

[Dave Peterson]

msgbox activesheet.cells(1,YourColumnLetterHere).column