Get the address of duplicates in a range

[YasserKhalil]

Hello everybody
I have data in range("A1:A100") I want a message box of the address of duplicates
say in A2 and A15 are the same value
A6 and A99 have the same value

Message Box should be like that :
A2:A15
A6:A99

Thanks advanced..

[kalak]

try

Please Login or Register  to view this content.

[YasserKhalil]

Thak you very much sir for this fantastic code