On Error GoTo - something crashes

[VitoBdG]

I have written a long code, creating 5 different pivots, though If some data did not appear in specified period I would like to ommit this table.

Therefore I have created a code in type of

Please Login or Register  to view this content.

(5 loops this way^^)

Though it does freeze after filtering with KM at first.

The purpose was to skip 1 pivot if unable to filter with criteria.

Could you help me out?

[VitoBdG]

about to fall off the page, so dragging up

[Norie]

Why not test to see if the relevant data exists in the pivot table, or source data, before trying to set the current page?

[VitoBdG]

Did not work much with "Find" in VBA..

Would be much better though

[Norie]

Have you tried using COUNTIF or another worksheet formula via Application.WorksheetFunction?

[VitoBdG]

You sir are much helpful!

TYVM! Worked