What code should I use if I want to delete entire Rows (and then move all
other rows below up) if the value in say Sheet1 A1:A.... is not within a
named range, say 'Product Numbers'.

I may have to set-up a Dynamic Range for the values in Sheet1 A1:A.... as
they will change in Row numbers daily - so I would want the code to search
until the last value in Column A Sheet1.

I'm looking to place this code in a macro.

Thanks