Excel cell reference

[Lucas]

How can I get something like

A1
B1
...
Z1
AA1
AB1
...

I tried

Macro Macro5

Code:

Copy      Help

int i
str s
for i 0 100
,s.format("%c%i" 'A'+i 1)
,out s

but only works to z1...

[Gintaras]

Macro Macro1546

Code:

Copy      Help

out
int i
str s
for i 0 100
,if(i<26) s.format("%c%i" 'A'+i 1)
,else s.format("%c%c%i" 'A'-1+(i/26) 'A'+(i%26) 1)
,out s

[Lucas]

Perfect!

Thanks.

[Lucas]

Other way:

Function GetExcelColumnName

Code:

Copy      Help

function~ n;;1='A'
str cn
rep
,if(n<=0) break
,n-1
,_s.format("%c" 'A'+(n%26))
,cn-_s
,n=n/26
ret cn