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" <(E-Mail Removed)> wrote in message
news:AA76A7FE-922E-4A11-A69B-(E-Mail Removed)...
>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