Hi,

In Excel VBA the columns and column properties can be used to return the numeric equivalent of the column. Is there a way to actually return the column letter.

I know you could create an array to hold A,B,C etc.. but I was just wondering whether there was an easier and better way. I have tried the address and addresslocal properties and they return the whole range i.e. "A:A" or "A3:A67" what I would like is something to just return A

Is there an easy way to do this...

Cheers
Steve