![]() |
|
#1
|
|||
|
|||
![]()
perhaps something along the lines of this
Code:
Sub RemoveKeyWordRows() Dim lr As Long, i As Long, cel As Range, temp As String Application.ScreenUpdating = False lr = Cells(Rows.Count, "A").End(xlUp).Row For i = lr To 2 step -1 temp = "" For Each cel In Range(Cells(i, "A"), Cells(i, "E")) temp = temp & cel.Value & " " Next cel '(keywords-loan,financial,bank,equity) If InStr(temp, "loan") > 0 Or _ InStr(temp, "financial") > 0 Or _ InStr(temp, "bank") > 0 Or _ InStr(temp, "equity") > 0 _ Then Rows(i).Delete Next i Application.ScreenUpdating = True End Sub Last edited by NoSparks; 12-06-2017 at 09:55 AM. Reason: step |
![]() |
Tags |
excel vba, macros |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
liliaroma | Word VBA | 4 | 11-18-2017 07:53 PM |
Automatically Delete Slides based on current time | Pacman52 | PowerPoint | 2 | 07-16-2015 05:30 AM |
How to Automatically Add/Delete Columns Based On Information | kconnolly | Excel | 7 | 04-08-2014 07:23 AM |
Find and Delete Rows based on a range | damaniam | Excel Programming | 2 | 03-12-2014 06:06 AM |
![]() |
donaldadams1951 | Word VBA | 5 | 12-03-2013 10:08 AM |