| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop the loop after it runs for 10 times.
Hi,
I want to run the below mentioned loop for only 10 times. Does anyone know how to stop the loop after it complete 10 rounds. Sub LOOP12() Do Until ActiveCell.Value = "" If ActiveCell.Value = 10 Then ActiveCell.Offset(0, 1).Value = 15 End If ActiveCell.Offset(1, 0).Select Loop End Sub Regards Heera |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to stop other macros while current macro runs | Excel Programming | |||
| Can you code a macro so it runs multiple times in the same workboo | Excel Discussion (Misc queries) | |||
| ADO command.execute with a loop - only runs once | Excel Programming | |||
| HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming | |||
Threaded Mode
