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
(5 loops this way^^)
Please Login or Register to view this content.
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?
about to fall off the page, so dragging up
Why not test to see if the relevant data exists in the pivot table, or source data, before trying to set the current page?
If posting code please use code tags, see here.
Did not work much with "Find" in VBA..
Would be much better though
Have you tried using COUNTIF or another worksheet formula via Application.WorksheetFunction?
You sir are much helpful!
TYVM! Worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks