IfError then change cell values, and then change them back

I occasionally get a #VALUE! or #DIV/O! errors all over the place in a workbook.

I know that if I then change a particular cell's value, and change it back, all of the errors go away, and yet I cannot understand how to get rid of the error. For example it will be a #DIV/0! error but every cell and its antecedents having the error does not contain any division by zero.

So I can't seem to prevent the error from coming, but know how to fix it when it does (strange, i know). Recognizing that, what I am wondering is if there is a way using VBA to say:




(1) IF range contains an error then set all cell values in range equal to 0.

(2) Then switch all the cell values in range back to what they were before.




I could really use some help on this...

I'll try to reproduce the error on-demand. Good advice.