How to Access Sheets (Worksheets, Charts, Dialogs) Using Name/Index in Excel Macro

Below Example will show you how we can Access various sheets like worksheets, charts, modules, and dialog sheets  using name in Macro.

Macro Code / Syntax  -


Worksheets("Sheet1").Activate
Charts("Chart1").Activate

DialogSheets("Dialog1").Activate

In above code we are accessing the sheet1, chart1 and dialog1 using Excel Macro.