VBA help needed to capture Error and Remove Pivot if error exist else resume

Hi I am no programmer. By reading threads and such I created a spreadsheet which has multiple macros. Basically a report generator.

Excel version 2010

Current Setup:
On Load () I am forcing pivot tables to have certain filtering.

Problem:
When that filter is not available I am getting a VBA error. Or if I resume on Err. Filter is selected as whatever is available next (creates confusion on reporting)

Proposed Resolution:

I think I need to come up with a way where I check if error exist or not and move next. If exists I would like to remove the pivot table and move next, if no error than resume next.

However, I have no clue how to achieve this. Would really appreciate guidance.

Thank you!

If you post your code, that would be helpful. But you could try code like this with multiple error handlers, where you could customize the response to errors.

Please Login or Register  to view this content.

This is how I would handle the first 3 (7 through 9)

Please Login or Register  to view this content.