cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
galactus3000
Level IV

I have some cells selected ... how do I set the values of those cells?

I have a script which has already selected a set of cells.

Now I want to set those cells to have a certain value, say 6.3201

why doesn't the following work?

set selected cells(6.3201);

I know how to select the cells and don't need help with that

I need help with how to take a group of selected cells and simple want to place a value in them

thanks

 

 

1 REPLY 1
txnelson
Super User

Re: I have some cells selected ... how do I set the values of those cells?

Assuming the selected cells are all in the same column, and let's say the column is named "X", you would set the values
X[ dt<<get selected rows ] = 6.3201;

I am also assuming that you have specified prior to the above:
dt = current data table();
Jim