Returns an IRange interface that represents the used range on the specified worksheet.

[Visual Basic]
Property ReadOnly UsedRange As IRange
[C#]
IRange UsedRange { get; }
[C++]
__property IRange* get_UsedRange();
[JScript]
function get UsedRange() : IRange

Property Value

IRange interface.

Example

This example sets the font style in used cells on the first sheet to italic.

[C#]
book.Worksheets[1].UsedRange.Font.Italic = true; 

[Visual Basic]
book.Worksheets(1).UsedRange.Font.Italic = True

[C++]
book->Worksheets->Item[1]->UsedRange->Font->Italic = true;

See Also

IWorksheet Interface | NativeExcel Namespace | IRange Interface

---