Is this what you saw

On Error Resume Next
sColumn = Split(Columns(Col).Address(, False), ":")(1)
On Error GoTo 0


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
can somebody help me out? i can't remember the columns command i used or
where
i used it, to return the column letter of a column.

it's not a function, it doesn't return the address, or use the left
property or
anything like that, i think it was just using the columns property.

hopefully i explained it well enough. it was simple when it came to me,
but i
can't remember it for the life of me.

--


Gary