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
|