Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Searching Worksheets for related items and then highlighting matching row
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