Previous Topic Next Topic

Cell.find

Closed
Fong - 14 May 2010 à 05:46
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 14 May 2010 à 06:05
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
14 May 2010 à 06:05
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.