| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Leave loop
so I have this part of the loop doing what I want.
For i = 3 To 100 Worksheets("Shapes").Range("I5:I7").Copy If IsEmpty(Worksheets("MAG").Cells(i - 1, 1)) Then Worksheets("MAG").Cells(i - 1, 1).PasteSpecial Paste:=xlPasteValues, Transpose:=True Next However, I want it to stop right after it pastes and leave the for loop. So basically it reads the page where ever the next blank row is it pastes then stops. thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| returning back to loop check condition without completing the loop | Excel Programming | |||
| Loop to Filter, Name Sheets. If Blank, Exit Loop | Excel Programming | |||
| Leave Log | Excel Discussion (Misc queries) | |||
| Advancing outer Loop Based on criteria of inner loop | Excel Programming | |||
| Leave last col alone | Excel Programming | |||
Threaded Mode
