Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ALPHA/NUMERICAL SORT | Excel Discussion (Misc queries) | |||
Alpha & Numerical Help Needed | Excel Worksheet Functions | |||
Alpha/Numerical numbers | Excel Worksheet Functions | |||
Change the column designation from a numeric to an alpha | Excel Discussion (Misc queries) | |||
alpha column changed to numerical column | New Users to Excel |