F
Fred Smith
I am setting an Autofilter with:
Selection.AutoFilter Field:=3, Criteria1:=Household
However, sometimes Household doesn't exist in the table. How do I test to
see if the selected range is empty? Is there a way to test whether Household
exists in the Criteria1 list? Or is there a test to see if the
Autofilter.Range is empty?
Selection.AutoFilter Field:=3, Criteria1:=Household
However, sometimes Household doesn't exist in the table. How do I test to
see if the selected range is empty? Is there a way to test whether Household
exists in the Criteria1 list? Or is there a test to see if the
Autofilter.Range is empty?