ADD_ROW_AFTER

Uses expression to search in a frame to select a set of row(s) in it and then inserts the range/frame after the selected row(s) returned by expression.‌

Syntax

ADD_ROW_AFTER(targetFrame, searchExpr, frameOrRangeToAdd, [addAll])

• targetFrame - Target Frame.

• searchExpr - Search Expression.

• frameOrRangeToAdd - Frame/range to add.

• [addAll] - Add all rows? (FALSE by default)

Sample Usage

ADD_ROW_AFTER(C1, "@number = 2", C2)
ADD_ROW_AFTER(C1, D1, A6:B6)

Return Value

• TRUE if function modified the targetFrame.

• FALSE otherwise.

Notes

In order for ADD_ROW_AFTER to work, the first argument targetFrame must be a FRAME.

See Also