You can write this code in a module sheet in VBA. If you cannot see a
module sheet, then insert one by going to Insert - Module.

Also, after Z it will not proceed to AA because the ACSII code for A i
65 and increases by 1 for each letter i.e 66 for B and so on. If yo
want it to go to AA then repeat the same code in a loop once i
reached Z.

Let me know how you went. If you continue to have problems, I shal
write the code for you next time but I would rather have you have a g
at this first.


Best regards


Deepak Agarwa

--
Message posted from http://www.ExcelForum.com