I want to write a macro that applies .AutoFilter to a range,
I have got this far
" Selection.AutoFilter Field:=1, Criteria1:="#REF!", Operator:=xlAnd"

BUT what is the syntax when "#REF!" does not apear in the filtered list so I
can return the list to the original condition and not make any changes?
Thank you
Peter147