Countif and Delete Macro/Formula Issues

I have a formula in M2 that goes down to the last row and looks for the value "0" in the specified column and if the value is present it will show "delete"

Then in N2 I have a countif formula that will take the data and delete the rows with that value.

This works perfectly UNLESS the count is 0 - I had to add +1 as well because before I did that it would always exclude the last row with that value. The sheet has a header row so I don't want that to get deleted.

Is there a better way to write this? I have this formula throughout my macro several times and don't want to gamble on whether or not there will always be the value needed to ensure the macro doesn't cause this problem.

Please Login or Register  to view this content.

Do you need the formulas in M and N for some reason? Or do you set them up only so the code knows what to delete? If the latter, this code is a very convoluted way to do this.

You also have macro recorder bloat in the code.

I would delete columns M and N and do this:

Please Login or Register  to view this content.