Convert Column Number to Letters MS Excel 2007 update

Example of what code does is as follows

If Column number = 1 then A
26 = Z
27 = AA
702 = ZZ
703 = AAA
729 = ABA
etc...

Thanks to royUK for first posting the Excel XP version of the code! With Excel 2007 a little additional coding was required to fully utilize all the additional column available

Please Login or Register  to view this content.

Here is another way, I think...

If the active cell is the target:

Please Login or Register  to view this content.

If the number is returned from another line of code, or a user input:

Please Login or Register  to view this content.

Hi

With the above function Column number 832 returns "AF@" instead of "AFA"

Any suggested solution for this?

Simply

Please Login or Register  to view this content.

Originally Posted by BrianPanicco

Hi

With the above function Column number 832 returns "AF@" instead of "AFA"

Any suggested solution for this?

I wonder why that does this for you. Column 832 is AEZ. However, when I ask for column 833, it returns "AFA" as expected
I included a line that would go the the column referenced so you can see.

Please Login or Register  to view this content.

Thanks a million

They are two different ways of approaching the problem. The one I posted is a called subroutine and not a function with manual input. As someone pointed out in another post, in the other code certain columns may not convert properly. I included the test code to demonstarte the effectiveness across ALL columns up to 16384 (XFD).