|
|
SPLICECELLS function
Replace up to 5 cells with values in an array.
SPLICECELLS is a multi-threaded, non-volatile array function.
SPLICECELLS Syntax
SPLICECELLS (Range_Array, Rows, Columns, Splice [, Rows2, Cols2, Splice2] [, Rows3, Cols3, Splice3] [, Rows4, Cols4, Splice4] [, Rows5, Cols5, Splice5] )
Range_Array
Array, Table, Range or Spill reference be spliced.
Rows (Optional, default -1)
Optional: the row number in Range_Array at which the cell will be replaced, -n = the nth row counting upwards from the bottom, +n = the nth row counting downwards
Cols (Optional, default -1)
Optional: the column number in Range_Array at which the cell will be replaced, -n = the nth column counting leftwards from the right, +n = the nth column counting rightwards from the left
Splice (optional)
Optional.: the value to replace the cell found at Rows, Cols
|
|
