View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Holmes Fred Holmes is offline
external usenet poster
 
Posts: 112
Default 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