Using Go To to Jump to a Chart Sheet

When you want to jump to a specific worksheet in a workbook, you can use the Go To feature of Excel to make the jump painless, in the following manner:

1. Press F5. Excel displays the Go To dialog box. (Click here to see a related figure.)
2. In the Reference box, enter MySheet!A1. (Replace "MySheet" with the name of the worksheet you want to jump to.)
3. Click OK.

This works great for regular worksheets, but it won't work if you want to jump to a chart sheet. Why? Because Go To is used to jump to specific cells (in this case, cell A1 on MySheet), and chart sheets have no cells you can reference.

If you want a quick way to jump to a chart sheet, you will need to resort to a macro. You can have the macro ask for a chart sheet name, and then use the Activate or Select methods with the sheet name. The pertinent line of the macro--the one that does the actual "jumping"--can be either of these:

Sheets("MyChart").Activate
Sheets("MyChart").Select

All you need to do is substitute the proper name of the chart sheet in place of "MyChart."