Anybody have some code to convert a column letter to it's column number
equivalent?
--
Andrew

Function courtesy of Chip Pearson:


Function ColumnNumber(ColLetter) As Integer
ColumnNumber = Cells(1, ColLetter).Column
End Function



"slymeat" wrote:

Anybody have some code to convert a column letter to it's column number
equivalent?
--
Andrew

and from bob phillips
'-----------------------------------------------------------------
Function ColumnLetter(Col As Long)
'-----------------------------------------------------------------
Dim sColumn As String
sColumn = Split(Columns(Col).Address(, False), ":")(1)
ColumnLetter = sColumn
End Function


--


Gary


"Toppers" wrote in message
...
Function courtesy of Chip Pearson:


Function ColumnNumber(ColLetter) As Integer
ColumnNumber = Cells(1, ColLetter).Column
End Function



"slymeat" wrote:

Anybody have some code to convert a column letter to it's column number
equivalent?
--
Andrew

colNum = Range(colLetter & "1").column

where colLetter is a variable with the letter(s) in it.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"slymeat" .(donotspam) wrote in message
...
Anybody have some code to convert a column letter to it's column number
equivalent?
--
Andrew

A simple one:
Sub Test()
colname = InputBox("Enter column")
'This is the one that does the trick
outp = Columns(colname).Column
MsgBox ("col no is " & outp)
End Sub

slymeat (donotspam) wrote:
Anybody have some code to convert a column letter to it's column number
equivalent?
--
Andrew

Thanks to all those who answered this. I only need one, but this will help
me also.

"Toppers" wrote:

Function courtesy of Chip Pearson:


Function ColumnNumber(ColLetter) As Integer
ColumnNumber = Cells(1, ColLetter).Column
End Function



"slymeat" wrote:

Anybody have some code to convert a column letter to it's column number
equivalent?
--
Andrew