filter table data using named range

[Bnagel]

Ive recorded the following Macro to see what the VBA would be when filtering by >=1

Please Login or Register  to view this content.

How can I modify this to look at cell named range ("rng_dih") instead of "1"?

I want to be able to change the value in ("rng_dih") and have the list refilter.

[PCI]

See next code

NOT TESTED

Please Login or Register  to view this content.

[Bnagel]

Thanks for the relay but I took a different approach.

Please Login or Register  to view this content.

[PCI]

Excellent, you got it by yourself ...!