Hi
one way (in vBA):
msgbox
mid(cells(1,col_index).address,2,instr(2,cells(1,c ol_index).address,"$"
)-2)

--
Regards
Frank Kabel
Frankfurt, Germany

"tich1234 " schrieb im
Newsbeitrag ...
I have a spreadsheet where the column number is dynamic, ie it
changes
based on a access query from which the spreadsheet is exported.

Can anybody tell me how to find the column letter(like A,B, C...AA,
AB)
if I know the coulm number(like 1,2,3...27,28).

In other words how do I find the column letter if I know the column
number.

Thanks,

William,


---
Message posted from http://www.ExcelForum.com/