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

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?

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?

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