Delete worksheet rows
1. wdelrows del:=1 skip:=9 start:=1;
2. wdelrows m:=1 r:=col(a);
Please refer to the page for additional option switches when accessing the x-function from script
Input
Worksheet
Specifies the source range.
int
Reduce method.
Option list:
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.
Output
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.
wdeldup