I have a spreadsheet that matches a value in one column to another...,
basically to check for duplicates...then the duplicates show up in
another column. I want macro to count the number of matched values and
return a comment that states that "X number of matches are found." If
there were no matches, it should say "No Matches Found."

I appreciate your assistance.

Thanks!

In which group would you like your answer. Pls post in ONLY one.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Damil4real" wrote in message
...
I have a spreadsheet that matches a value in one column to another...,
basically to check for duplicates...then the duplicates show up in
another column. I want macro to count the number of matched values and
return a comment that states that "X number of matches are found." If
there were no matches, it should say "No Matches Found."

I appreciate your assistance.

Thanks!