Remembering Column Numbers Associated with Column Letters

I like these formulas enough to use them regularly in VBA. I don't like them enough to change my Excel interface over to R1C1 style numbers. So I routinely have to know that the cell known as U21 is really R21C21.

Knowing that U is the 21st letter of the alphabet is not something that comes naturally. We have 26 letters, so A is 1 and Z is 26. M is the halfway point of the alphabet and is Column 13. The rest of the letters are pretty non-intuitive. I found that by playing this little game for a few minutes each day, I soon had memorized the column numbers:

Ans = InputBox("What column number is the letter " & Chr(64 + i) & "?") If Ans = 1111 Then Exit Do

Was this article helpful?

0 0

Post a comment