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.
--
Robert Hill

In a cell:
=COLUMN(A1)

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Robert" wrote in message
...
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.
--
Robert Hill

Try:-

=COLUMN(E1)

Would return 5.

Mike

"Robert" wrote:

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.
--
Robert Hill

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


--
Hope that helps.

Vergel Adriano


"Robert" wrote:

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.
--
Robert Hill

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


"Robert" wrote:

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.
--
Robert Hill

msgbox activesheet.cells(1,YourColumnLetterHere).column



Robert wrote:

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.
--
Robert Hill

--

Dave Peterson