Hello,

I am currently trying to create filter that would update pivot table based on named range. So far I have following code:

Please Login or Register  to view this content.
My problem is when I run the macro I get Error 1004 "Application-defined or Object-defined error"
If you know how to fix it your help would save me a lot of time when filtering manualy,

Thank you for your help