Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Elton,
I see that you checked my second post as the correct answer but based on your later comment that the loop should run until error and you don't know how many times that will be then you should replace the loop code with the following code and then it does not matter if less than or more than 100 loops. The called sub code can remain as per my previous post. Sub RunInLoop() errorFlag = False 'Initialize to false Do While errorFlag = False Application.Run "SkyDaysHour_X31_H2_Hour" Loop End Sub -- Regards, OssieMac |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
repeat number multiple times | Excel Discussion (Misc queries) | |||
Repeat text a number define of times | Excel Worksheet Functions | |||
Why can the number of iterations repeat many times as a loop?? | Excel Discussion (Misc queries) | |||
Repeat statements "x" number of times... | Excel Discussion (Misc queries) | |||
how do I get a calculation to repeat various number of times? | Excel Worksheet Functions |