Clears the active worksheet or matrixsheet of a specified window and sets the number of rows to 30.
win -o %1 (work -clr)
This macro takes one argument, the workbook name containing the sheet to be cleared. The macro should be called with the following syntax:
The script below clears the Sheet2 worksheet in Book3.
Book3!page.active$ = Sheet2; // The sheet to be cleared must be active
ClearWorksheet Book3; // The window need not be active
The wclear X-Function does not have active window or sheet requirements.