Find text in string
 

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!

Find text in string
 

Have a look at

InStr

Sub findwords()
x = InStr(ActiveCell, "on hand")
MsgBox x
End Sub
--
Don Guillett
SalesAid Software

"Mike D." <Mike wrote in message
...
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!

Find text in string
 

Sub Macro1()
If InStr(ActiveCell, "on hand") Then ActiveCell.EntireRow.Delete
End Sub

Regards,
KL

"Mike D." <Mike wrote in message
...
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!

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!

Find text in string
 

Thanks, Folks! The INSTR works well.

Mike.

"Mike D." wrote:

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!

Find text in string
 

glad to help

--
Don Guillett
SalesAid Software

"Mike D." wrote in message
...
Thanks, Folks! The INSTR works well.

Mike.

"Mike D." wrote:

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!