• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Working with PivotTables using VBA


Well-Known Member
Hi All,

Came up with a new Tutorial for Working with PivotTables using VBA. Covers how to create pivots, add/remove/format pivotfields, add calculated fields, change data range, hide errors, filter.

Please note this is not for Beginners. You must have a basic understanding of VBA as well as the use of variables. It is also not for beginners as it is not explained in depth. There is a resources sheet at the end of the Tutorial for in depth learning.

PDF file is the Tutorial. Excel File is the sample file with the macros related to the tutorial.