Hi,

I have vba that compares the cells in A1:A10 with the cells in B1:B10.
If the value in A1 is not found in the range b1:b10 I get the error #N/
A in C1.

At the end of my code I would like to display a msgbox with a prompt

("These values were not found;")

and then a list of the values (the ones that caused the #N/A error in
column C

But I do not know how to do this.

Any help is very much appreciated.