How to: Refer to Sheets by Name
Last modified: June 30, 2011
Applies to: Excel 2013 | Office 2013 | VBA
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