I have a worksheet in Excel with values in some rows in column B that have been returned as zero (0) but still have a formula in the cell. I want to be able to delete just these rows using a macro.
As a software tutor I'm surprised you did not already know how to do this (or is this question just a test?) However, the following code may help:
but I would recommend that (i) you turn on macro recorder and create the macro for yourself and (ii) take extreme care with any macro not created by yourself - in particular one that contains 'Delete' in it!
Note this deletes