Hi All,
I was wondering if it is possible to reference a dynamic criteria range when running an advanced filter in VBA.
What I have is this:
The criteria is on a different sheet named "List". There is multiple criteria within the range.Please Login or Register to view this content.
I'm looking to dynamically reference that criteria in VBA so I don't have to change the hard coded value reference every time the list criteria changes.
Any help would be greatly appreciated, thanks!
Bookmarks