Thread: mapping columns
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default mapping columns

Does this do what you want...

ColumnNumber = 5
ColumnLetter = Split(Cells(1, ColumnNumber).Address(1, 0), "$")(0)

--
Rick (MVP - Excel)


"Farooq Sheri" wrote in message
...
Greetings

Is there a way to map column number to alphabet such column 6 equates to
"F"
and column equates to AA.

Thanks