I have a macro that has a vlookup formula from a linked spreadsheet. After
calculation i paste special values. If the data is not found it puts a #N/A
in column B of my spreadsheet. I want to search column B for value #N/A and
if i find any instances, jump out of the macro and throw up a message box.
can someone help me with this? Also i do not know how long column B will be.
so i should probably start at the last cell in column B that contains data.
Thanks.