problem with multiple PivotTables on a PivotCache

[rick.hunter.007]

Hello there!!!! (Sorry about my bad english, it's not my native language)

I need a little help for a Pivot Table's programming problem...

i got a "Runtime Error '5'" when i want to create a second PivotTabel from a PivotCache Object (the same)... My code is this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

''''''''''''''OK, I NEED TO CREATE n PIVOT TABLES IN A SPECIAL SUB....

Please Login or Register  to view this content.

Everything goes well the first time that i make a PivotTable...
But when i want to create a second PivotTable from the same PivotCache i got an error '5'...

Please Login or Register  to view this content.

Please help meee, i'm just a Begginerrrrrrrrrrrrr

[rick.hunter.007]

I have found the solution of my problem...

Please Login or Register  to view this content.

I don't know why... the person who did this macro use the other function form....
But the answer was to use the "ActiveSheet.[B7]" part.....

[VBA Noob]

rick.hunter.007,

Thanks for sharing the answer

VBA Noob