Pivot Table Error

[realniceguy5000]

Hi,

This should be an easy one,

Can someone help me with why this script isn't working.

It is suppose to remove the (blank) check mark from the activesheets pivot table.

I'm getting a (Object doesn't support this property or method)

Please Login or Register  to view this content.

Thanks as always for your help...

Mike

[VBA Noob]

This seems to work for me

PS. No need to select the sheet first

Please Login or Register  to view this content.

VBA Noob

[realniceguy5000]

Thanks VBA Noob,

I thought I could figue this out with a little help, However I guess I need a bit more.

The problem is I have more that one worksheet with pivot tables,Your code worked for the first sheet. so I tried to add the following code to change to work with all the pivot tables

Here is my new code trying to move from worksheet to worksheet doing the same thing.

Would you mind taking a look at it again, Many thanks for your input!!! Good and Bad...

Thanks Again... Mike

Please Login or Register  to view this content.

[VBA Noob]

Maybe

Please Login or Register  to view this content.

VBA Noob

[realniceguy5000]

Thank You Again...Really seems so simple when you spell out the anwser. Being that close must mean I am getting some what better.

Well I will just take this as another of many lessons learned on this Great site.

Once again thank you...Mike