Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What is the code you would use to go down a column (starting at cell A7) and
delete 3 rows below the active cell when the next cell is different than the active cell. The loop can/should stop whenever the statement above is true (next cell < current cell). I was able to make it work with a for...next loop, but I think there has to be a better loop, probably a Do...Loop. I tried for hours to use a Do..loop but I couldn't get out of the loop when the condition was met... Just curious...Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
Naming Worksheets - Loop within a loop issue | Excel Programming | |||
(Complex) Loop within loop to create worksheets | Excel Programming | |||
Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
Problem adding charts using Do-Loop Until loop | Excel Programming |