Get the Sheet's Used Range

Retrieve the used range of 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
sheet	The reference to the Excel sheet.	excel sheet reference	Yes

Output Concepts

Concept	Description	Type
sheet's used range	The used range of the sheet.	excel range reference

Examples

Retrieve the used range of an Excel sheet.

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