This documentation is archived and is not being maintained.
How to: Refer to Sheets by Name
You can use the Sheets property to return a worksheet, chart, module, or dialog sheet. The Sheets collection contains all of these kinds of sheets. The following example activates the sheet named "Chart1" in the active workbook.
Sub ActivateChart() Sheets("Chart1").Activate End Sub