Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding a charcter in a text string (take2)
I am trying to write a macro to find if an item exists within a cell and if so keep the row on which the cell resides cell or else delete it.
For example in the cell will be the text "London, Brimingham, Bristol" and I would like to put a search cname for London and have the row kept, but if I typed in Liverpool the row would be deleted. The search name is on another worksheet in the spreadsheet. The code I currently have is the following: LRow = 1 While IsEmpty(Range("K" & CStr(LRow)).Value) = False If Range("M" & CStr(LRow)).Value < Range("SM!D6") Then Range("A" & LRow & ":T" & LRow).Select Selection.Delete ' Decrement counter since row was deleted LRow = LRow - 1 End If LRow = LRow + 1 Wend How can I get the code Range("SM!D6") to include a subset that is the search name? SM is the other worksheet name and D6 is the cell where the search name is chosen. Thank you in advance. Bulent. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a charcter in a text string | Excel Worksheet Functions | |||
Finding specific text in string - Part II | Excel Worksheet Functions | |||
Finding specific text in a string | Excel Worksheet Functions | |||
Finding a text string w/in a Cell | Excel Discussion (Misc queries) | |||
Finding Specific Text in a Text String | Excel Worksheet Functions |