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


Messages In This Thread

Forum Jump:


Users browsing this thread: 1 Guest(s)