Macro to search for a text string
 

Hi. i need to create a macro that will search for a particular string.
is this possible?

Macro to search for a text string
 

Something like this?
Dim sString as String
sString="WhateverYouAreLookingFor"
Cells.Find(What:=sString, After:=Range("A1"), LookIn:=xlFormulas,
LookAt _
:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:= _
False, SearchFormat:=False).Activate

tc wrote:
Hi. i need to create a macro that will search for a particular string.
is this possible?

Macro to search for a text string
 

tc

This is much less specific than the earlier and similar question you asked
(and didn't respond to). What would you like to do when you find this string?

Mike

"tc" wrote:

Hi. i need to create a macro that will search for a particular string.
is this possible?

Macro to search for a text string
 

On Sep 11, 6:48 pm, Mike H wrote:
tc

This is much less specific than the earlier and similar question you asked
(and didn't respond to). What would you like to do when you find this string?

Mike



"tc" wrote:
Hi. i need to create a macro that will search for a particular string.
is this possible?- Hide quoted text -

- Show quoted text -

hi. to be more specific i need to search for a string named "Grand
Total" on a worksheet and then delete the entire row which contains
this value