Delete rows with zero and #NUM!

  • Hi,

    Ive been trying to write a macro that deletes only rows with zero, but I also want to delete #NUM! Errors. Is there a way to delete rows with 0 and #NUM! Starting from row A18:A392? And is it possible to do the macro for just the new sheets after using another macro that creates a new sheet from a template?

  • Re: Delete rows with zero and #NUM!

    This should delete cells with 0 and with Errors in Column A:

    Matt Mickle
    Using Excel 2010,2013 & 2016

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!