String Contains a Value
If ACtivecell.Value Like "*name*" Then
ACtivecell.Entirerow.Delete
End If
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Lynn" wrote in message
...
I would like a certain action to be carried out if a specified string is
found anywhere within the active cell. What code can I use to evaluate
the
condition?
Eg if Customer is found anywhere in the active cell, I want to delete the
current row.
|