P116 Change the Value or Formula of a Cell or a Range of Cells (command line example list)

Example:

 Command Line Example 1: Change the contents of a sheet.

 

P116 Command Line Reference:

/P#

Meaning

Extra Parameters

116

Change the Value or Formula of a Cell or a Range of Cells

/1 = sInputSheet(s) (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(s) by name or by number to modify.

    You may specify ranges by index:  i.e. "2-4,10" or "*" for all.

    You may specify by name: i.e. "Sheet4","Sheet6","Accounting"

/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.