I want a macro that will refresh several pivot tables. Also, the data source of the pivot tables may have more rows in it, so it needs to select range("A1").currentregion on the same tab.

Any ideas on how to accomplish this?