Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Why won't this stop looping? Where did I go wrong. It works fine but
it goes on and on. thanks in Advance Public Sub RowFix() Dim c As Variant Dim FirstRow As Integer With Worksheets(1).Range("A6:A4000") Set c = .Find("01152", LookIn:=xlValues) If Not c Is Nothing Then FirstRow = c.Row + 1 Do Until IsEmpty(ActiveCell) c.EntireRow.Insert c.Offset(-1, 0).Value = "Next" Set c = .FindNext(c) Loop End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop Loop | Excel Programming | |||
Do Loop doesn't stop | Excel Programming | |||
Hot key to stop a LOOP | Excel Programming | |||
how to stop a loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |