T O P I C R E V I E W |
mwambach |
Posted - 08/23/2016 : 6:48:44 PM Hi!
I would like to use wcellcolor to highlight certain rows in a worksheet. Somehow the use of variables in the code didn't work. Does anyone have a suggestion how to do this?
e.g.: 'wcellcolor [i+5] color(orange);'
Cheers! |
2 L A T E S T R E P L I E S (Newest First) |
mwambach |
Posted - 08/24/2016 : 12:25:46 PM Thanks, Amanda! |
AmandaLu |
Posted - 08/23/2016 : 10:46:15 PM Hi mwambach,
The input of wcellcolor X-Function is a range. So you will need to use the correct range notation. For example, if you want to color a range from 5th row in 1st column to 10th row in 2nd column, you can use script:
wcellcolor 1[5]:2[10] color(orange);
Please refer to this page for how to use range notation:
http://www.originlab.com/doc/LabTalk/Tutorials/Tutorial-Range-Notation
Thanks, Amanda OriginLab Technical Service
|
|
|