Hi, I try to set column parameters, but get Command Error: newbook name:="Duomenys T290K" sheet:=3; newsheet name:=Bandinys1 cols:=5; Up to this point script works, but then: [Duomenys T290K]Bandinys1!col(1).digitmode=1; [Duomenys T290K]Bandinys1!col(1).digits=4; Returns an error. What is whong in the script? Jonas
range c1=[Duomenys T290K]Bandinys1!col(1);
c1.digitmode=1;
c1.digits=4;
Generally speaking, the range notation, in this case [Duomenys T290K]Bandinys1!col(1), is not an object, just a notation to give the specification of the range. Range IS an object. So, first you make the range object, then specify its property like digitmode.
range c1=[Duomenys T290K]Bandinys1!col(1);
c1.digitmode=1;
c1.digits=4;
Generally speaking, the range notation, in this case [Duomenys T290K]Bandinys1!col(1), is not an object, just a notation to give the specification of the range. Range IS an object. So, first you make the range object, then specify its property like digitmode.
Setting column parameters
Posted - 10/13/2017 : 10:34:09 AM
