Column Designation Conversion - alpha/numerical
 

Is there a function that will directly "translate" between the letter
designators for Excel columns and the equivalent column numbers?

Cells(n,m) uses a number to designate the column.

I'm looking for a function, f(m), that returns the equivalent letter
designation for display in a TextBox. Also the function that will
take the letter(s) [text] entered into a text box and return the
column number for use in the Cells() formula. e.g. m = g("CB")

I could write the parser, but if there is a built-in function, I'd
rather use it.

Thanks,

Fred Holmes

Column Designation Conversion - alpha/numerical
 

Fred,

Here is a simple UDF posted previously by Gord Dibben. Just pas sit the
column number

Function GetColLet(ColNumber As Integer) As String
GetColLet = Left(Cells(1, ColNumber).Address(False, False), _
1 - (ColNumber 26))
End Function


--

HTH

RP

"Fred Holmes" wrote in message
...
Is there a function that will directly "translate" between the letter
designators for Excel columns and the equivalent column numbers?

Cells(n,m) uses a number to designate the column.

I'm looking for a function, f(m), that returns the equivalent letter
designation for display in a TextBox. Also the function that will
take the letter(s) [text] entered into a text box and return the
column number for use in the Cells() formula. e.g. m = g("CB")

I could write the parser, but if there is a built-in function, I'd
rather use it.

Thanks,

Fred Holmes