Duplicate Entries in Excel

[MisterM1]

Hello ,
Please Help me , it's so complicated for me
Regards

[p45cal]

see attached

[MisterM1]

it works with the first files but it doesn't work with this one
I do not know where is the probs

[p45cal]

Change:
Set myrng = Intersect(myrng, myrng.Offset(2))
to:
Set myrng = Intersect(myrng, myrng.Offset(1))

…

[p45cal]

…or the attached.
When you get asked:

2019-10-06_131813.jpg

[MisterM1]

Thanks a lot,
it,s work fine

[MisterM1]

Thanks a lot,
it,s work fine

so Where to click solved

[Paul_Hossler]

Thanks a lot,
it,s work fine

so Where to click solved

Above your first post, [Thread Tools], and click [Solved}