Find text in string
Hi
Instr, like
S = "neon hand sign"
If InStr(S, "on hand") 0 Then MsgBox "Found it"
HTH. best wishes Harald
"Mike D." <Mike skrev i melding
...
Hi. Within a loop, I would like for the macro to find the text "On Hand"
within a cell on a given row. If the text exists anywhere in the cell, I
would like to delete the row.
What command should I use? I know that if I wanted to find this in the
left
or right of the string I would use the LEFT or RIGHT function, but I don't
know how to have it search anywhere in the string. Thanks!
|