Forum Discussion
Play a Pivot Table on recorded macro
Hi,
I was asked to create a report according to the chiefs (Chief 01, Chief 05, Chief 09...) found on the data base. I recorded a macro and assigned it to a button that would create a Pivot Table, however whenever I try to play it for a second time, it shows error and sends me to the code. What should I do?
I was asked to create a report according to the chiefs (Chief 01, Chief 05, Chief 09...) found on the data base. I recorded a macro and assigned it to a button that would create a Pivot Table, however whenever I try to play it for a second time, it shows error and sends me to the code. What should I do?
1 Reply
Hi
Purely recording macros, especially relatively complex ones like creating Pivot Tables, are a bit of a recipe for disaster to be honest.
The main solution is to look at and understand the code. Unfortunately there's not trick to this you just have to learn it.
