View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KS Wong[_2_] KS Wong[_2_] is offline
external usenet poster
 
Posts: 13
Default character representation of specific column

Dear all,

Is there a simple way in VBA to get the character representation of specific
column? For example, activesheet.cells(1, 2) = row = 1, column = "B" I guess
using chr(activesheet.cells(1, 2).column + 64) could do the job from "A" to
"Z". How about "AA"...?

Thanks in advance!