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

Last updated

Was this helpful?