Delete Worksheet
The Delete Worksheet function deletes the specified worksheet from the report. This is useful if the worksheet is being used for “temporary” calculations for the final report workbook. Before applying this function, make sure that that there are no links referencing it from other sheets.
Settings | |
|---|---|
Worksheet | The name of the worksheet to delete. This can be a fixed name or a cell reference where the cell contains the name of the worksheet to delete. |
Active Worksheet | The name of the worksheet to activate after the Worksheet specified is deleted. This can be blank, a fixed name or a cell reference where the cell contains the name of the worksheet to activate. If left blank and the worksheet to delete is the active worksheet, the next worksheet to the right becomes active. If the worksheet is the rightmost worksheet, then the worksheet immediately to the left becomes active. |
Range | The range to select on the Active Worksheet if it is specified. This can be left blank if it is not needed. |
Example
An On Demand batch report is used to compare multiple batches. This report is constructed by configuring a separate worksheet containing a sub-report representing a single batch. For each batch specified for the report, the sub report is populated and copied to the report. On completion, the worksheet representing the sub report is no longer required and can be deleted.
Setting | Value |
|---|---|
Worksheet | SubReport |
Active Worksheet | Report |
Range |