Hi

I have a sheet which I use a macro to save as a csv file.

What I would like to do is search column H and if #N/A is found (from vlookup) then I want to display a message box to say #N/A found and then stop the macro from continuing.

I know that an IF statement needs to be used and I know how to find the value, but cannot work out where to start on how to get the message box when found and stop the macro from running.
I only need to find the value once even though there may be multiple instances.

Many thanks in advance for taking a look and any suggestions.

Dan