Delete worksheet rows
1. wdelrows del:=1 skip:=9 start:=1;
2. wdelrows m:=1 r:=col(a);
Specifies the source range.
Delete rows according the specified reference column. Script accessible only.
Number of rows to delete.
Number of rows to skip.
Starting row to begin deletion.
Ending Row to Delete. Script accessible only.
The output range.
See the syntax here.
This X-Function deletes worksheet rows by one of the following method:
By default, this function will delete the entire row if any cell in the row satisfies the condition you selected. If you want to delete rows that refer to some other columns, you should run this function by script.