Find Values With VBA04 Oct 2012 http://www.rondebruin.nl/find.htmThe above website has some great snippets of code which can:Use Find to select a cellMark cells with the same value in column A in the B columnColor cells with the same value in a Range, worksheet or all worksheetsCopy cells to another sheet with Find