Macro to find data in column

I have set up a macro to find a particular number in a column:

Please Login or Register  to view this content.

This works well, but I was looking for some code to find duplicates as well so tried this:

Please Login or Register  to view this content.

As my worksheet is password protected, this didn't work without

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

etc., which made the whole thing slower than it is. It's pretty rubbish code anyway. The first one does not find duplicates but works well.

The second one will come up with with error message 1004 ("You cannot use this command on a protected sheet" etc.) as long as

Please Login or Register  to view this content.

etc. isn't included.

In Tools>Protection>Protect Sheet, I have allowed users to use AutoFilter, so I don't know what the problem is and perhaps there is some better code for this anyway.

meridius10,

Could try something like this instead:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

Brilliant - that's surpassed what I was after.

Now I must look at your code and see how I can approach a problem like this in a better way next time.