UsedRange property

This property returns a range object that represents the used range (modified or containing data) on the specified sheet. If the sheet is empty, it returns the range (A1:A1).

Defined in

Sheet

Data type

Range

Syntax

public Range getUsedRange()

See examples

Example: UsedRange property