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
|