How to "on error resume next" with a filter ?

[patricia75]

I want to delete the rows selected by an autofilter in my macro. It works well when I have rows matching the criteria.But when there is no row corresponding to the criteria I got a msg "error 1004" no cell were found. I tried to use "on error resume next" but I still get the message error. Any idea how I can solve that ? Thanks !

 

[wigi]

Did you write the On Error Resume Next ABOVE the filtering part in the code?

 

[patricia75]

Yes above the filtering part and then I added On error goto 0 after

 

[Marcelo Branco]

Patricia,

Maybe this can help
http://www.rondebruin.nl/delete.htm

Take a look at
Use AutoFilter to delete rows

HTH

M.

 

[patricia75]

Thanks a lot Marcelo.

 

[Marcelo Branco]

You are welcome and tks for the feedback

M.