Macro to Clear Row Based on Formula Value

I am working on a sheet where I have a bunch of formulas in columns A1-K500. Here is what I am trying to accomplish:

If the formula in cell A1 (or A2, A3, etc) returns a "0" then I want the cell contents in A1 thru K1 to be cleared. If it does not return a 0 then the row should be left alone. This needs to happen for about 500 rows or so.

Is there a Macro for this? I was able to figure out how to hide the row if A1 is 0 but for formatting purposes, I need to leave the rows visible on the sheet.

Thanks!

Hmm, if I copy that code exactly, it is not working. Thanks for your response though!

Try:

Please Login or Register  to view this content.

Just a note that based on your original post, you indicated if the formula = 0, you want to clear the row including the formula? So the formula is erased as well?

@ptmuldoon - Good question.

Yes, I need everything to erase, including the formulas. I found this on another thread and I think it is working.

Please Login or Register  to view this content.