convert column reference from number to string

[ncic_1]

Hey I have a real simple question I was wondering how to change a number into a string equivalent of a column reference.

ex. 1 would be "A"
2 would be "B"
3 would be "C"

and so on.

I thought that I could just use Columns(1) to get the string "A" but it doesn't seem to work.

Thanks for your help.

 

[Von Pookie]

It can be done; this thread may help:
http://mrexcel.com/board2/viewtopic.php?t=105935

 

[ncic_1]

thanks, I looked into the thread and I am pretty sure that it is what I am looking for.

Just tried it out (the very last solution) and it works great.
Thanks again.