Find Values With VBA
http://www.rondebruin.nl/find.htm
The above website has some great snippets of code which can:
- Use Find to select a cell
- Mark cells with the same value in column A in the B column
- Color cells with the same value in a Range, worksheet or all worksheets
- Copy cells to another sheet with Find