VBA to display message box if a value in a column is found then stop the macro

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

After you find a N/A write

Please Login or Register  to view this content.

it will stop macro at the time and continue after you click OK.
If you want to exit sub then write

Please Login or Register  to view this content.

after Msgbox

Maybe:

Please Login or Register  to view this content.

thanks both.

John, how can I limit the amount of rows it searches through (to 14001 only) and for the loop be stopped if #N/A is not found?

Thanks

Dan

try

Please Login or Register  to view this content.

Originally Posted by dantgk1

thanks both.

John, how can I limit the amount of rows it searches through (to 14001 only) and for the loop be stopped if #N/A is not found?

Thanks

Dan

Please Login or Register  to view this content.

thank you both for your time in helping me with this.

Dan

You're welcome Dan. Glad you got you're problem solved.

Hello Dan,

Is it possible for you to attach the excel file with the solution?? That will be a great help for us.

Thanl you!