Duplicate Entries in Excel

[MisterM1]

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

[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:banghead::banghead::think:

[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:

25235

[MisterM1]

Thanks a lot,
it,s work fine:friends:

[MisterM1]

Thanks a lot,
it,s work fine:friends:

so Where to click solved

[Paul_Hossler]

Thanks a lot,
it,s work fine:friends:

so Where to click solved


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