peltiertech.com
Referencing Pivot Table Ranges in VBA - Peltier Tech Blog
This tutorial explains how to reference various parts of a pivot table using VBA code.