Macro to Filter Pivot Table not working when the Value does not exist

Hi All,

I am working on one report that contains 2 pivottable with some conditions, but when any one of them does not meet, macro gives me error.

for my report i have 1st pivottable with selection of 261, 262 and 2nd pivottable with selection of 551,552.

but when any one of them is missing in master report then macro gives me error, how to come with result still any one is missing.

Please Login or Register  to view this content.

Hi,

Please edit your post to use code tags, in accordance with the forum rules.

Either select the code in the edit window and click the # button on the toolbar, or type [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] after it.

Thank you.

You can use a simple On Error Resume Next thus

Please Login or Register  to view this content.

Repeat the above with any other fields you are filtering.