Can't resolve PivotTable Property error.

[dwhite30518]

I am trying to use the following code...

Please Login or Register  to view this content.

I keep getting an error relating to PivotTable Properties when the codes gets to this portion of the code...

Please Login or Register  to view this content.

And I am going nuts trying to resolve. Can anyone please give me some insight or assistance to resolve this issue?

[Izandol]

What is actual error?

I will suggest you continue to use PVT variable:

Please Login or Register  to view this content.

[dwhite30518]

I was getting the following error....

"Run-time error '1004':
Unable to get the PivotTable property of the Worksheet class"

And I am getting that error every time the code gets to this portion...

Please Login or Register  to view this content.

So if I use your amended code, then that should resolve this issue?

[Izandol]

You may try it and tell me.

[dwhite30518]

Nice!!!

Awesome!!!! Thanks...it works like a charm now.

[Izandol]

You are welcome.