Filter Pivot table based on Range

Hi, I have been trying to figure this one out for a while and am at my wit's end. I came across another post on this forum that does almost what I am looking for (that code is below); the only difference is, I need the Range "B3" to be multiple cells; the cells I need to call from will always be A2:A11, or I could put it into a named range. Can someone help me to edit this code so it will do multiple cells? Thank You!

Please Login or Register  to view this content.

p.s. to give credit where credit is due the above code came from a forum user by the name "T-J"

The function Filter_PivotField below does what you describe.
The examples show how to call it with a Range Address reference or Named Range.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi and thanks again for your help!
I am getting an error, "Wrong number of arguments or invalid property assignment". Here is what I have done with your code:
1. I copied the public function (Filter_PivotField) and inserted a new module in my workbook, then pasted the code in there. I did not tweak any of that code.
2. I then created a new macro, "Temp 1" and pasted in and tweaked the below code:

Please Login or Register  to view this content.

"UOM Data" is the sheet which contains the Pivot Table.
"Dept Lines" is the sheet which contains the range I want to reference (A2:A11)
"Dept Name Dept Number" is the name of the field I am trying to filter in the pivot table.

Does anything right away pop out that I have done wrong?

Thanks!

Try replacing this line of code in the Function Filter_PivotField

Please Login or Register  to view this content.

If that doesn't fix it, please attach a copy of your workbook with any sensitive data removed.
(It's very nice that ExcelForum supports file attachments!)

JS411, Thank you very much! It worked perfectly once I made that change!

Also, for anyone who may come across this forum searching for answers to this type of problem, I also got this code to work correctly (However, this only works for a static range, what JS411 provided above can be dynamic:

Please Login or Register  to view this content.

Hi to All

Could someone give me specific instructions about the how to use the codes above?

I have copied the Public Function to a separate module in my work book.
In another module i have the Sub Example2()


Is there any specific name i must use for the sub example2()???

i get this error:

Compile error:

Wrong number of arguments or invalid property assignment

Notes*
I have replaced the

Please Login or Register  to view this content.

Thank you in advance