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).
Bookmarks