|
/P# |
Meaning |
Extra Parameters: /1{Parameter1} … /n{Nth Parameter} |
|
116 |
Change the Value or Formula of a Cell or a Range of Cells |
/1 = sInputSheet (by name or by number) /2 = sRange (Specify which cells to change. (leave blank for ‘used range’) /3 = sNewContent (what is it you want to change the cell content to) /4 = bChangeFormula ("TRUE" to modify the Formula, or "FALSE" to modify the Value) |
This special process will modify the contents of a cell or a range of cells to any value you specify.
Special Parameters Described in Detail
/1 = sInputSheet Specify which sheet by name or by number to modify.
/2 = sRange A string to optionally specify the range to do the search and replace on. For example /3“D:D” will do column D only.
/3 = sNewContent Here you can specify what you want to change the cells content to. Be sure to look at the last parameter to specify whether or not this parameter is a Value or a Formula
/4 = bChangeFormula If you are change a formula then a value of “TRUE” should be used, otherwise use “FALSE” to change the contents of the Values of the cell.
Examples: