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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dwipper

  1. dwipper

    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...
  2. dwipper

    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.

Part and Inventory Search

Back
Top