No Records Found (autofilter)

I have a macro which filters a record set with a criteria. Sometimes there will be filtered records other times not. I would like to do an If Then Else based on the filter displaying or not displaying rows. What follows is my failed attempt.

**Code Snippet

Please Login or Register  to view this content.

****End of Code

Appreciate any help,
Brian

Hi bmcgrath

Please wrap your code in Code Tags.

Here's code I've used successfully...adapt to your needs (the Minus 1 is to eliminate the Header Row)

Please Login or Register  to view this content.

Thanks John.

Bmcgrath,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.