| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to find specific data in a cell, then delete that row on down
Sub DeleteRows()
Dim c As Range Set c = Cells.Find(What:="ASC database on SQL Server", _ After:=Range("B1"), LookIn:=xlFormulas, LookAt:=xlPart, _ SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False) Rows(c.Row & ":" & c.Row + 20).Delete End Sub Hth, Merjet |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find specific data in a cell and its colocated cell data | Excel Worksheet Functions | |||
| Macro to delete rows containing specific data | New Users to Excel | |||
| Macro to delete specific rows above selected cell | Excel Programming | |||
| How do i create a macro to find a specific data? | Excel Programming | |||
| macro to find date format in a cell and delete that entire row | Excel Programming | |||
Threaded Mode
