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

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

Glen
"Glen Mettler" wrote in message
...
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