|Rather than hiding the error, why not fix it? In most cases, hiding an error is dangerous because you may end up masking an error that you should be aware of.|
For example, if any of your calculations actually end up being 0, how would know which ones were valid and which ones were errors?
Share your formula and input data and perhaps we can offer a suggestion on how to eliminate the error.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.