the green tick mark generally indicates a resolved problem, in this forums
you can try like
vb Code:
set r = range("a1:j10") for each c in r set f = r.find(c.value) if not f is nothing then msgbox "cell " & c.address & " matches cell " & f.address next




Reply With Quote