How can I detect an AutoFilter when the Criteria isnt Met

[Frederick]

I am hoping someone may be able to help with this problem please.

I have a general routine which looks at several worksheets and sets up an
AutoFilter but there may be occasions when the Criteria I have built into my
code is not satisfied.

I am selecting through code an AutoFilter on a Worksheet and setting the
criteria to filter on as "Open" however if the criteria isn't satisfied
then the Filter returns ALL data in the selection this really messes up my
sheet I am storing my results into.

Is there any way I can detect if the criteria doesn't exist such as for
example

If AutoFilter.Criteria NotExists Then Skip

I would be grateful for any help offered

Thanks

Fred.

 

[Frederick]

Thanks to both Steve and Tom.

Tom this is just the thing I was hoping for thanks a Million.

Fred

 

[Frederick]

Tom I have tried out the code and it works perfect.

Thanks once again.

Fred