Combinations of objects,properties and command

Hi Felix

One way to learn how the VBA code works is to record a macro of tou doing the function on the screen.

So if you recorded a macro while you created a Pivot table and then observed the code it would give you an idea how the Pivot table code is written.

The code given to you in the Excel VBA Introduction course is an adaptastion of this using the PivotTableWizard method.

Hope this helps

Carlos