Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loop Macro
I created a simple Macro to Find and then delete certain rows.
Cells.Find(What:="Page", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate ActiveCell.Rows("1:1").EntireRow.Select Selection.Delete Shift:=xlUp End Sub I them wanted to make this macro loop through the column until all instances of Page were deleted. So I added Do Until ActiveCell.Value = " " at the beginning and Loop before the End Sub. It removed all the rows but a run-time error '91' appeared that stated Object variable or with block variable not set. How do I correct my loop statement to run correctly? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do until loop with use of another macro in loop | Excel Programming | |||
Loop Macro | Excel Programming | |||
VBA Macro Loop | Excel Programming | |||
Using for loop in a macro | Excel Programming | |||
I Need Help with my loop macro | Excel Programming |