View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andibevan[_2_] Andibevan[_2_] is offline
external usenet poster
 
Posts: 128
Default Covert Column Numbers to Column Letters in Excel VB

I can't find the specific number you add but you can use Val_ColumnLetter =
CHR(# + 64) function (where # = column number). The 64 is added because the
letter A is the 65th character in the ansicode sequency.

"Keith" wrote in message
...
Is there a Excel VB function that can take a column number and convert it

to
a column letter? I can write one on my own, but I hope that there is a

built
in function to do this. Some properties will only use column letters and
this presents a problem.

Thank you in advance for any help you can provide.