Forum Discussion
laucav32
Feb 15, 2017Copper Contributor
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, ...
Wyn Hopkins
Feb 28, 2017MVP
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.