VBA to select filter from pivot tables

[michelle 1]

Dear Excel Forum

I also posted this in the VBA Posts - not sure if i needed to do both as it is VBA/Pivot i need help with.

I have been using the below code to change the filter on my pivot tables based on the value in another cell and all works fine. However i set up my pivots slightly different in my current file, as i need to see unique values only i have created the pivot table and selected "Add this data to the data model". Using the same code below does not seem to be working on this pivot and i wondered if someone would be able to offer some help.

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-pro...ot-tables.html