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!
|