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

where lngColumn is the column number.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"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