// Set col(1)'s short name in active sheet as "Time"
wks.col1.name$ = Time;
But this code doesn't work for me. Can I change the column's short name? How do I access to column by its short name instead of its serial number, for example wks.col1. or col(1)?
Thank you.
--- Andrey
9 L A T E S T R E P L I E S (Newest First)
AKazak
Posted - 09/03/2020 : 12:16:40 PM Nikolay, CP
Got it. Thank you.
--- Andrey
cpyang
Posted - 09/03/2020 : 11:57:54 AM variables are local and automatically deleted on existing a scope. Typically we put codes into ogs sections which is a type of a scope.
Posted - 09/03/2020 : 11:09:36 AM Seems, right way is: del -ra rr;
Nikolay
nick_n
Posted - 09/03/2020 : 11:00:04 AM Hi,
What for you would like to clear range var? I've never done that. Try: range rr=%(); Not sure if it is legal :)) Best,
Nikolay
AKazak
Posted - 09/03/2020 : 09:41:26 AM
quote:Originally posted by nick_n
Hi,
range rr = A; rr.lname$=;
Nikolay
OK, got it. How do I clear memory of a range variable after using it?
--- Andrey
nick_n
Posted - 09/03/2020 : 07:54:43 AM Hi,
range rr = A; rr.lname$=;
Nikolay
AKazak
Posted - 09/03/2020 : 05:39:41 AM
quote:Originally posted by cpyang
You have to turn off SCN (Spreadsheet Cell Notation), so
page.xlcolname=0;
wks.col1.name$=Time;
Once you turn SCN off, you won't be able to use such notation in formula, so better just use long name?
wks.col1.lname$=Time;
CP
Got it!
I will continue working in SCN-on mode. How do I access to column by its short name instead of its serial number, for example wks.col1. or col(1)? Can I call something like wks.col(A) or wks.col("A")?
Thank you.
--- Andrey
cpyang
Posted - 09/02/2020 : 4:06:31 PM You have to turn off SCN (Spreadsheet Cell Notation), so
page.xlcolname=0;
wks.col1.name$=Time;
Once you turn SCN off, you won't be able to use such notation in formula, so better just use long name?