Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Updating Pivot Table Range in VBA
Dale, Thanks for the tip. Here's how I wound up solving this: 'Select the sheet I want to work with Worksheets("Quarterly Totals").Select 'Select first cell below headers Range("A2").Select 'Note: only needed last row since last column is static ' in this situation...- dwipper
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Updating Pivot Table Range in VBA
I am trying to figure out how, with VBA, to update the range covered by a pivot table. I tried to record a macro, but nothing of use came out. Any suggestions would be appreciated.- dwipper
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
