Advance filter dynamic criteria range

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:

Please Login or Register  to view this content.

The criteria is on a different sheet named "List". There is multiple criteria within the range.
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!

Bumping along

Hi !

Range("A:H").AdvancedFilter xlFilterInPlace, Worksheets("List").Cells(1).CurrentRegion …

Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !

Thanks Marc that did the trick!

Marking this as solved, thanks!