One of a few other options:

n=26, or 27
ColumnLetter = Left$(Cells(n).Address(False, False), (n <= 26) + 2)

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"tich1234 " wrote in message
...
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/