Vba code to check if there are formula errors and put them in a variable

[rpinxt]

So is there a simple way (without having to code an entire extra module) to 'capture' if there are #NA errors on a sheet.

Its like this.
I have a code which also opens a conversion worksheet and then the formulas update.
However if this conversion sheet is not complete or up to date the output will have "#NA" in some cells.

Not a big deal because the user can check and update the conversion and run the macro again.
However i would like to provide some sort of headsup at the end of the macro.

So a msgbox to not only state that the macro is done but also that there are NA's which they need to fix.
Depending if there are NA's the end message will be different (Al ok or update your conversion).

[xlnitwit]

Hi,

You may use a simple Countif calculation

Please Login or Register  to view this content.

[rpinxt]

Good suggestion!
Did a quick test for this and could work.

However how can I get it in some sort of a variable?

At the end of the VBA code it should check this variable and if there are error it should generate a different text in the msgbox than when there are no errors.

[xlnitwit]

Thus

Please Login or Register  to view this content.

[rpinxt]

Ah superb!
This I should be able to incorporate in my main code.
Thanks!