VBA If row count is 1 then

[Crispy85]

Hi,

I'm still pretty noob in vba so i might just ask.

I have this macro and one part of it is a sheet of mutations. Sometimes there are no mutations so the file only has a header.

The macro applies a autofilter anyways to look for a criteria. However, sometimes it cant find this because the list is empty.

Is there a easy If statement like:

if rowcount >1 then apply autofilter blabla
else if
nothing

Can someone help?

thanks

[NeedForExcel]

Something like this maybe?

Please Login or Register  to view this content.

[Crispy85]

Thanks man!

[NeedForExcel]

Glad it helped..

Please mark the thread as solved if you have your answer..

Cheers!

Deep