Reference>IXLSWorksheet>Activate

Makes the specified sheet the active sheet. Equivalent to clicking the sheet's tab.

Syntax

procedure Activate;

This example activates worksheet one.

Workbook.Worksheets[1].Activate;