A
ahperez
I am working to update the series source in a chart. I have an excel
template in which I copy 2 worksheets into my workbook.
I would like to edit one chart using my VBA code. I am getting Method
PlotArea of Object '_Chart' Failed.
The code is below.
Thanks for your help.
Sheets(1).Select
ActiveSheet.ChartObjects("WhatMatters").Activate
ActiveChart.PlotArea.Select
template in which I copy 2 worksheets into my workbook.
I would like to edit one chart using my VBA code. I am getting Method
PlotArea of Object '_Chart' Failed.
The code is below.
Thanks for your help.
Sheets(1).Select
ActiveSheet.ChartObjects("WhatMatters").Activate
ActiveChart.PlotArea.Select