Test for #NUM! in cell

[JimDandy]

I have some code that I don't want to execute if the value in a particular cell is not calculated due to missing data and has the #NUM! in the cell. How do I test for this condition in VBA? The code I'me trying to use is below and the #NUM! is in cell D40

Please Login or Register  to view this content.

[:) Sixthsense :)]

May be change this

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[AB33]

Change the AND to OR if necessary

Please Login or Register  to view this content.

[JimDandy]

Thank you all very much!