Delete visible rows after applying autofilter - not working

Hi, there are a lot of similar posts like this but I can't seem to get the following code to work using the different methods suggested. I'm pretty new to this so am probably making an obvious mistake!

What I'm trying to do is filter my data and then remove the filtered results.

When I step through the code it comes up with error code '1004 - No Cells Found' on the last line.

Please Login or Register  to view this content.

Would appreciate any help or advice!

Thanks
Jo

hi Jo, welcome to Excelforum, try this out:

Please Login or Register  to view this content.

Thanks so much for your help, that worked!!