Formula To Increment Alphabetical Letters ?

[Aitch]

I use this to drag down alphabetical letters:
=CHAR(CODE(A1)+1)
It works, but only up to Z!

What do I use to continue the sequence through to double letters like this:
AA
AB
AC
AD

Thanks for your help!

 

[Aitch]

Standard Module
How to install your new code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)


To run the Excel VBA code:
Press Alt-F8 to open the macro list
Select a macro in the list
Click the Run button

Appreciate your help bro!

Is there a book or website you would recommend for beginners to learn VBA?

 

[alansidman]

https://www.mrexcel.com/products/microsoft-excel-2019-vba-and-macros/