Reference>IXLSWorksheets>Count

Returns the number of sheets in the Worksheets collection. Read-only Integer.

Syntax

property Count: Integer;

This example uses the Count property to set the value of A1 cell on the first sheet.

Workbook.Sheets[1].Range['A1','A1'].Value := Workbook.Sheets.Count;