Column reference

[Glen Mettler]

I need to capture the alpha address of a column. For example, I know that
column 5 is "E" but how can I do that programmatically?
Suppose I have column 37 - how can I capture the alpha address?

Glen

 

[Glen Mettler]

Disregard. I got it from www.dicks-blog .com

ColLetter = Left(Cells(1, ColNumber).Address(False, False), _
1 - (ColNumber > 26))
neat!!

Glen

 

[Rob van Gelder]

strColumn = Split(Columns(lngColumn).Address(, False), ":")(1)

where lngColumn is the column number.