Find text in string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
Have a look at

InStr

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

Regards,
KL
 
Hi

Instr, like

S = "neon hand sign"
If InStr(S, "on hand") > 0 Then MsgBox "Found it"

HTH. best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find and scroll to cell string value in Excel 2
Find Text String 5
Make Macro Work On A Different PC 5
Conditional Formatting VBA with formula to find string 3
find text in a string 5
VBA set thick borders around non empty cells in range 0
Add to a "number as text" 10
Find and move cells with text 8

Back
Top