Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find text in string
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Find Specific Text in a Text String | Excel Discussion (Misc queries) | |||
Search, find or lookup defined text in text string | Excel Worksheet Functions | |||
can you find specific text in a string ignoring any other text | Excel Discussion (Misc queries) | |||
backwards find function to find character in a string of text | Excel Programming | |||
How to Find text in String? | Excel Programming |