Macro to find value in worksheet

[John T. Moran]

I've been asked if I could come up with a macro or vba that I could
enter a list of names in the code and run the macro to find any matches
of the names in the open worksheet. I'm a newbie at this and I'm lost.

Is there anyone who could help me with this code? It seems like such a
simple task but I know better.

I'd have to enter about 100 names individually and do a find every day
to see if certain names were in this sheet. The sheet changes every day,
the names don't. I'd rather have the names hard coded in the macro and
just run it and have it pop up a message saying "these" names has been
found and if not another message saying nothing found. It needs to
search all cells in the sheet.

Any help would be appreciated. Thanks.

John

 

[J.E. McGimpsey]

You might want to see if one of the techniques here will work for
you:

http://cpearson.com/excel/duplicat.htm