AndyPandy
asked on
Excel Error on ActiveSheet.ChartObjects("Chart 1""").Activate
Hi Experts,
How to fix this?
The image below shows the error I get when the macro attempts the line:
ActiveSheet.ChartObjects(" Chart 1""").Activate
"Chart 1" is shown on the worksheet, as can be seen,
yet the macro cannot find it (stupid macro).
Google shows this is a common question, yet I haven't found a answer.
How to fix this?
The image below shows the error I get when the macro attempts the line:
ActiveSheet.ChartObjects("
"Chart 1" is shown on the worksheet, as can be seen,
yet the macro cannot find it (stupid macro).
Google shows this is a common question, yet I haven't found a answer.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The Macro recorder put those extra quotes in, I do not know why.
Thank you