Reference>IXLSWorkbook>ActiveSheet

Returns an object that represents the active sheet in the specified Workbook. Returns Nothing if no sheet is active. Read-only.

Syntax

property ActiveSheet: IXLSWorksheet;

This example sets the name of the active sheet.

Workbook.ActiveSheet.Name := 'NewName';