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. |
All times are GMT +1. The time now is 11:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com