Hi All,
I have recorded a macros to create the pivot charts.When I run it for the first times it does well, however for next time when I run it , it throws an error.The error is due to the sheet where the pivot chart is stored , it don't allow me replace it with new pivot charts.As I am new to VBA , I dont have much info abt coding. Can anyone help me on this. What I need is it shld either repalce the existing pv charts with new one or delete the existing sheet containing pv chart and create the new one with tab name as "Pivot Data".Hope I had posted in correction section
. I have attached the sheet for ref.
tx
I have recorded a macros to create the pivot charts.When I run it for the first times it does well, however for next time when I run it , it throws an error.The error is due to the sheet where the pivot chart is stored , it don't allow me replace it with new pivot charts.As I am new to VBA , I dont have much info abt coding. Can anyone help me on this. What I need is it shld either repalce the existing pv charts with new one or delete the existing sheet containing pv chart and create the new one with tab name as "Pivot Data".Hope I had posted in correction section
. I have attached the sheet for ref.tx