The correct way of referencing the data source for a pivot table... error

Can anyone find the problem with this? Is there some reason why you can't use variable ranges in pivot tables?

Please Login or Register  to view this content.

I asked the same Q here in response to another question's answers:http://stackoverflow.com/questions/1...in-the-same-da

run time error 5 invalid call procedure...
it breaks on the activeworkbook.pivotcaches line

Please Login or Register  to view this content.

run time error 5 invalid call procedure...
it breaks on the activeworkbook.pivotcaches line

Please Login or Register  to view this content.

Is this a typo: ran9e.
I would expect range...