VBA: Filtering Power Pivot - Visible Item

Wasn't sure if this should be here or in VBA

I've started using power pivots rather than regular pivots and the way I previously used to filter using VBA doesn't work. The code below gets as far as clearing filters ok but the next part which is checking each item for a specific string doesn't do anything, Neither of the message boxes I've put in popup.

Please Login or Register  to view this content.

Thanks Rory, I seem to be getting a similar issue though. The code runs without any error but the pivot is left with all items visible.

I've just copy/pasted your code into a new VBA sub, changed pivottable2 to pivottable3 and ran it.

There are over 1000 *INC* matches when I filter the pivot manually. For some reason with my pivot/data it's not finding anything as sticking a

Please Login or Register  to view this content.

at the end is also blank.

If I record a macro of me running a manual filter here's a snap of the output.

Please Login or Register  to view this content.

Originally Posted by rorya

If you step through the code is it finding any matches?

Nope, It doesn't even touch the first IF.

Are you sure the table is not actually called Range2, rather than Range 2?

Originally Posted by Bob Phillips

Are you sure the table is not actually called Range2, rather than Range 2?

Hi Bob, It's definitely 'Range 2' as shown when I manually record a filter macro.

Originally Posted by rorya

Which version of Excel are you actually using?

I'm running 2016.

Originally Posted by rorya

I've only got 2010 available here, so I'll try and verify the code on 2016 later on.

Thanks again.

Originally Posted by rorya

I've only got 2010 available here, so I'll try and verify the code on 2016 later on.

I already did Rory, it works for me on 2016.

Thanks, guys.

I'll rebuild my data and try the code again.

Thanks for all your help.

I've recreated the data range on another sheet and have the same issue. It's not easy for me to cleanse the data to upload so I'll have to go back to regular pivots for now.