|
SPLICEROWS function
Removes and/or replaces rows within a range, array or spill reference, after a specified row or at the beginning or end of the range/array.
SPLICEROWS is a multi-threaded, non-volatile array function.
SPLICEROWS Syntax
SPLICEROWS (Range_Array, [AfterRow], [RemoveRows], [Splice], [Fill])
Range_Array
Array, Table, Range or Spill reference be spliced.
AfterRow (Optional, default -1)
Optional: the row number in Range_Array after which rows will be inserted or deleted, -1 = at the end of Range_Array, 0 = at the start of Range_Array
RemoveRows (Optional, default 0)
Optional: the number of rows to be removed from the Range_Array, Default 0 = no rows, -1 = all rows after AfterRow
Splice (optional)
Optional.: the array, range or spill ref to be inserted into Range_Array after AfterRow
Fill (optional, default #N/A)
If Splice has fewer columns than Range_Array the Fill value will be used to fill the missing cells after insertion into Range_Array. Default is #N/A.
|
