Need Macro to Find Contents of Active Cell

Hello!

I have a worksheet with over a thousand client names. Sometimes there are duplicates. I want the user to be able to click on a name (active cell), click a button that I will insert, which will then find and zoom to the next duplicate name. I've searched many forums, but most of the macros are for finding a cell on another sheet. I tried to tweak the macro with no luck. :/

Thanks,

TD

Maybe:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Originally Posted by Richard Buttrey

Once you've found the next duplicate what do you then want to do?

What about filtering the column of names for a particular name and you'll then see all the duplicate names and no need for a macro at all.

There are many people that use the spread sheet, some with little excel experience. So, A click of a button makes it much easier.

Originally Posted by JOHN H. DAVIS

Maybe:

Please Login or Register  to view this content.

Thanks!

Although, it works for some and not others. Weird.

I have it setup to highlight duplicate cells, so I know that there are duplicate names.

Originally Posted by nilem

or

Please Login or Register  to view this content.

peerrrrrfect!!!

Thanks!