Error on PivotItems.Visible = False with dates

[tone640]

I have two pivot tables, both with the below excerpt:

Please Login or Register  to view this content.

The code works fine on one, but errors on the other when the count reaches the last value. The fields are dates on both, which has posed a few challenges already, but I can't see the difference between the two that is causing the error.

Thanks in advance for any suggestions.

[tone640]

For clarification, more code:

Please Login or Register  to view this content.

I get the error 'Unable to set the Visible property of the PivotItem class' as indicated in the above code.

[tone640]

Bump - can anyone help?

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

[tone640]

Much appreciated, Norie.