Message box if cell is duplicate

[GCLIFTON]

is there a way of having the below statement to state if there are duplicated have a messgae box state" Duplicates Found"

and if there are not

"No Duplicates Found"

Please Login or Register  to view this content.

[kev_]

Try this:

Add sub below to your module and amend your sub
replacing:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Please Login or Register  to view this content.