One important part of this is referencing the various ranges within a pivot table by their special VBA range names (which are actually properties of the Pivot Table object). I thought it would be helpful to show some of the mechanics of programming with pivot tables. These examples included specific procedures, and the emphasis was on the results of the manipulation. I’ve posted several examples of manipulating pivot tables with VBA, for example, Dynamic Chart using Pivot Table and VBA and Update Regular Chart when Pivot Table Updates.
