So I need to delete any row that has a value of either 0 or blank in my range of J7:J1006. I am trying to avoid an if/then statement to reduce run time. This macro is extremely quick for the blanks which I really like:
I have been trying to find how to alter the xlCellTypeBlanks to select any cells with 0 but I have not been able to. Is this possible? If not, how would you delete the cells with 0? I don't need a macro for the blanks since this one works great.
Please Login or Register to view this content.