Take no action when the search criteria is not found.

I use this macro to delete all the rows containing zero in the given column. Column K in this case.

Please Login or Register  to view this content.

It works fine and deletes the rows where there is a zero in K , leaving the rest of the data in place.

Unfortunately , if it so happens that there are no zeros in the column, it wipes out all of the data in the sheet except the header.

I wonder if there is a way to stop it doing this and leave everything intact in the absence of the search criteria.

Grateful for any advice.

Thanks Guys! It's working fine now.

Hi vcoolio - just wondering - could your code in post #3 be extended to report how many rows containing a zero in the chosen column were deleted?

Just a simple popup message box giving quantity deleted would be great if possible.

Try this.

Please Login or Register  to view this content.

Thanks all.

You're welcome and thanks for rep+.