A macro in Microsoft Excel to refer to sheets by name

Referring to Sheets by Name in Excel
You can use the Sheets property in Microsoft Excel to return a worksheet, chart, module, or dialog sheet. The example in the Excel training video activates the sheet named "Expense" in the active Excel workbook.
Sub ActivateExpense()
Sheets("Expense").Activate
End Sub

Custom Search

Further links
Referring to Sheets by Name [Excel 2003 VBA Language Reference]
Microsoft Excel Training Videos