VBA / update PivotTable source data

Hi,

I'm attempting to update a pivotTable's source data and I'm getting the "Run-time error '9':" error. Can any of you tell me what's wrong with my code? I've posted it below, and created it using the macro recorder and then altering it in the VBE. Thanks for your help.

Please Login or Register  to view this content.

change your code to this....I believe this will work

OLD

Please Login or Register  to view this content.

NEW

Please Login or Register  to view this content.

untested

Thanks for the attempt, but it didn't work. It was missing a ")". My adjustment to your code is below with the added ")". Any other ideas?

Yours:

Please Login or Register  to view this content.

With ")":

Please Login or Register  to view this content.

Here is made up version of what I'm trying to do. The pivottable is on the first sheet and the data is on the second.

BunnyPay.xlsx

Please Login or Register  to view this content.

Let's try this

did this help?

It didn't work. Whenever I include the sheet location and cell range in the same line of VBA code I always get errors. I decided to select the sheet first then the range. Thanks anyways.