Autofilter

[willpeg]

Hi guys
I need some help with this. As you can see from the code below I need some reference to detect whether or not there are any rows matching the autofilter criteria. I tried to use 'Cells (6,37)' but if the criteria is not in row 6 it fails. Hoping you can help. I feel it must be something quite simple but I can't see it.

Thanks

Please Login or Register  to view this content.

[mikerickson]

Please Login or Register  to view this content.

[willpeg]

Hi

I tried the code but could not seem to make it work. I tried with 1 row meeting the criteria and again with no rows meeting the criteria. What happened in both cases was the first message box came up and then the second.

Regards

[willpeg]

Hi Guys

I'm still looking for some aasistance with this little problem.

Thanks