Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do I stop the find at the end of the sheet
I need to handle the first find and delete a bit
differently than the rest. After the first one, I want to repeatedly search from a few rows down from the first one until the end of the sheet, doing deletes. How do I stop the loop from continuing back to the start of the worksheet, finding text that I intentionally left behind. -------- Range("A1").Activate Range(Cells.Find("PAUL INC").Offset(-2, 0), Cells.Find ("======").Offset(-3, 0)).EntireRow.Delete Range("A1").Offset(4, 0).Activate Do Until Cells.Find("PAUL INC") Is Nothing Range(Cells.Find("PAUL INC").Offset(-2, 0), Cells.Find ("======").Offset(1, 0)).EntireRow.Delete Loop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find empty cell then stop | Excel Discussion (Misc queries) | |||
Stop and start Sheet recalculation | Excel Discussion (Misc queries) | |||
How can you make the Find function stop when it reached the end | Excel Discussion (Misc queries) | |||
VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links | Excel Discussion (Misc queries) | |||
How to stop Excel from doing wrong Find/Replace | Excel Discussion (Misc queries) |