Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am a novice at writing macros and need what I hope is some easy to
obtain advice. I am trying to create a maco that will search for some text and when it finds it will then delete the row where the text appears and then continue searching for the same text. I have a simple do loop that works, but I don't know how to make it stop when it doesn't find the text. It errors when it can't find the text. Here is the code: Do Cells.Find(What:="Jackson Fish", LookAt:=xlWhole).Activate Range(Selection, Selection.EntireRow).Select Selection.Delete Shift:=xlUp Loop Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Validation Not Erroring with List | Excel Worksheet Functions | |||
VBA code erroring in XL97... | Excel Programming | |||
Custom Command Bar Erroring out when distributed | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Excel Erroring on Close | Excel Programming |