You don't need this for inside a macro
columns(3) is column C
range(cells(1,1),cells(1,3))

--
Don Guillett
SalesAid Software

"John" wrote in message
...
Dear ALL,

I got a question that maybe a minor one to everyone. but anyway, if I know
the column number, how do I know what "alphabeth letter" refer to it?
E.g.
I know the value c = 5 as referring column 5, but is there a way to return
the column letter "E" instead of 5? Please help since will need to use it
for setting formula inside macro. Many many thanks.

Regards,
John