convert column number to column letter

[ilkamalo]

in a macro i have this:
col=cell.column 'suppose col=16384
then i need to place in a cell this formula
=(XFD2708*100/XFD2597)-100

so i'm looking for "something" that can convert
16384 in XFD

i hope i have explain myself , thanks a lot

[DonkeyOte]

Best perhaps to enter the formula using R1C1 notation

Please Login or Register  to view this content.

That's not to say you can't convert the number to column string but there's really no need for it.

Please Login or Register  to view this content.

[ilkamalo]

thank for your help