How to: Programmatically Select Worksheets

Article
04/28/2015

The Select method selects the specified object, which moves the user's selection to the new object. Use the Activate method if you want to bring focus to the object without changing the user's selection.

Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2013 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

If you want to select an existing worksheet in an application-level add-in or if the worksheet was created at run time in a document-level customization, you must access it by using the Excel Sheets collection of the Excel workbook; otherwise, you can access the Worksheet host item directly.

Using the Worksheet Host Item

In a document-level customization, add the following code to Sheet1.vb or Sheet1.cs.

To select the first worksheet in a workbook using a host item

Call the Select method of Sheet1.

Globals.Sheet1.Select()

Globals.Sheet1.Select();

Using the Sheets Collection of the Excel Workbook

Access the worksheet by using the Excel Sheets collection.

To select the first worksheet in a workbook using the Sheets collection of the Excel workbook

Call the Select method of the Sheets collection to select the first worksheet of the active workbook.

CType(Me.Application.ActiveWorkbook.Sheets(1), Excel.Worksheet).Select()

((Excel.Worksheet)this.Application.ActiveWorkbook.Sheets[1]).Select();

How to: Programmatically Select Worksheets

Using the Worksheet Host Item

To select the first worksheet in a workbook using a host item

Using the Sheets Collection of the Excel Workbook

To select the first worksheet in a workbook using the Sheets collection of the Excel workbook

See Also

Tasks

Concepts

Additional resources