
Contents |
Clear Worksheet
Worksheet Clear
| Display Name | Variable Name | I/O and Type | Default Value | Description |
|---|---|---|---|---|
| Worksheet to clear | w |
Input/Output Worksheet | | Specify worksheet to operate on. |
| Reduce Row Size | reduce |
Input int | | Specify whether or not to reduce the row number to the default value. |
| Clear Operations | op |
Input int | | Specify whether or not to clear operation results that are associated with the worksheet. |
| Warning Message Box | msg |
Input int | | Specify whether or not to pop-up a warning message. |
| Start Row Number | r1 |
Input int | | Specify the start row number, from which to the end, the data will be cleared. |
This function is used to clear the worksheet data from a specified row to the last row.