Cell.find

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, I would like to ask for help to make this macro search for a "text" in a certain range. Please help. Thank you, Fong

Cells.Find(What:="text", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Replace cells with range. It would be either

Range(your range here).find

or

Range(your range here).cells.find

I think it is the later, you just have to test it.