Clear the Worksheet Range

Clears the contents of a range in an Excel sheet.

This procedure is part of the Excel Book (BDK). To use this book, you must first learn it in your agent.

Input Concepts

Concept	Description	Type	Required
worksheet range	The reference to the Excel range.	excel range reference	Yes

Examples

Clear the contents of a range in an Excel sheet.

get the first sheet
use the above as the sheet
get the sheet's used range
clear the worksheet range