Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel cell reference
#1
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...


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)