| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop through rows using a wildcard.
Very close and with a little tweeking it works fine. Actually, I neede to delete rows that were < the conditions. So, I just added th "ELSE". Thanks again for your help and God bless! For i = lastRow To beginRow Step -1 If LCase(Cells(i, 1).Value) Like "*bankruptcy*" Or _ LCase(Cells(i, 1).Value) Like "*cashiering*" Then 'Do Nothing Else Rows(i).Delete End If Next -- mthoma ----------------------------------------------------------------------- mthomas's Profile: http://www.excelforum.com/member.php...fo&userid=2564 View this thread: http://www.excelforum.com/showthread.php?threadid=39273 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Rows using If and Wildcard | Excel Worksheet Functions | |||
| Delete Rows using Wildcard | Excel Worksheet Functions | |||
| Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va | Excel Worksheet Functions | |||
| loop to insert rows | Excel Programming | |||
| Cannot loop through rows in C# | Excel Programming | |||
![mthomas[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
