Finding matching values

[Nanditha]

Hi friends… I am looking at your expertise in the below.
I have 2 excel worksheets (dnd and cc5). I have a set of values (text) in column A. I need to highlight the matching values between sheet dnd (column A) and cc5 (column P) in green text in column P.
I used the below command but it only finds the values which is in A4. Rest of the row values are not getting highlighted.

Sheets(“dnd”).Select
Range(“A3”).Select

For Each cell in Test.columns(“A”).cells.specialcells(xlcelltypevisible)

selection.offset(1,0).select
Sheets(“cc5”).select
Cells.find(what:=sheets(“dnd”).range(“A4”),searchdirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate

can someone help me to correct the code which is match all values in column A with cc5 sheet column P.
Thanks a lot for your help!

 

[Nanditha]

Then why didn't you say so?
Which line is highlighted when you click debug?

Sorry.. The line highlighted in yellow in the image I shared.

 

[Fluff]

You have a typo, it should be Rows not Row

 

[Nanditha]

Oops I have corrected it and it works fine. Thank you soo much for your help!
You have a typo, it should be Rows not Row

 

[Fluff]

You're welcome & thanks for the feedback.