When I record a macro and, in the process, click on a
chart, the macro code includes the following:
ActiveSheet.ChartObjects("Chart 12").Activate
Is there another place to find the number (Chart 12) that
excel has assigned to its charts? I am thinking there
must be a way to get this infomation other than recording
a macro.
Bookmarks