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