Question
May 11, 2007 at 05:12 AM
lucy_okia

Searching Worksheets for related items and then highlighting matching row

by lucy_okia . Updated 19 years, 5 months ago

I am writing a Macro in Excel that will compare two Worksheets within the same Workbook to find matching entries.

Step 1

Sheets(“SheetName1”).Select
Range(“B2:B1926”).Select
Selection.Copy
Sheets(“SheetName2”).Select

Step 2
Use the Selection from SheetName1 and Search SheetName2 for matching entries.
If found in any cell then
highlight the Row.

I need to somehow modifiy the code below to find and highlight all matching entries in SheetName2 in one run:

Cells.Find(What:=(“???”) After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Rows(“???”).Select
Selection.Interior.ColorIndex = 6

This discussion is locked

All Comments