Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Assuming you found "money" and/or "header", do you want to delete the
same amount of rows each time? If so, you could do create 2 ranges: one for HEADER and one for MONEY. then offset them and delete the rows accordingly. Maybe something like this? Dim rngMoney As Range Dim srchMoney As Range Set srchMoney = Cells.Find("money") If Not srchMoney Is Nothing Then Set rngMoney = Range(srchMoney, srchMoney.Offset(0, -9)) End If and do the same for "header"..... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find and delete all other rows | Excel Discussion (Misc queries) | |||
Find & delete rows with ID's from another sheet. | Excel Discussion (Misc queries) | |||
how do i find and delete all empty rows in an excel worksheet | Excel Worksheet Functions | |||
Macro to find and delete rows! | Excel Discussion (Misc queries) | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) |