Cell.find
Closed
Fong
-
May 14, 2010 at 05:46 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 14, 2010 at 06:05 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 14, 2010 at 06:05 AM
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
Cells.Find(What:="text", After:=ActiveCell, LookIn:=xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 14, 2010 at 06:05 AM
May 14, 2010 at 06:05 AM
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.
Range(your range here).find
or
Range(your range here).cells.find
I think it is the later, you just have to test it.
