Msgbox reports first #N/A it encounters in the entire workbook.

[Anne Troy]

I have posted this at Answers.Microsoft. I don't seem to be able to get the solution I need.

http://answers.microsoft.com/en-us/o...b-2b280bd57fcd

I have a workbook where I run quite a bit of code and copy a bunch of user-input data to arrange it for import (performed by SQL script).

Great.

Except the user needs to copy some data to another worksheet and use it there, too. Then...they see a typo and fix it. Now, I am trying to find ID's I've assigned and I can't because my vlookup now throws a #N/A.

So, when they try to finalize the data for import, I want to throw some error-checking in up front so they know they've got #N/As to fix. Most have learned how to fix it, but when the data is large, it can be a pain to check for it, so I want to check for it automatically.

The first #N/A that the code comes across should throw up a msg box that says "Error found at Sheet1!A1" or similar, and a button to go to that cell. Everything is halted, the user fixes the #N/A and runs the finalize again. The next #N/A will throw up a msgbox. And so on until no #N/As are found. If that's the case, the msgbox does NOT come up, my procedure will just call the next procedure.

So, something like:
Sub Finalize()
Call FindNAs
Call FinalizeMe
End sub

I need the FindNAs part.



I am happy to email my real file to anyone on this board.

[Ken Puls]

Send it to me, Anne. I'll take a look.