Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling execution of a Sub Procedure
I have a spreadsheet that itself has a recursive (iteration) loop. Once the
sheet converges, I have to look at the results and depending on what they are, either call a lengthy Sub procedure or bypass it. I cannot use Function procedures because the lengthy calculation I must perform is itself iterative. Thus I can't break up the calculation into a number of small Function procedures. I am now using the worksheet_calculate() event handler, but evidently the definition of "recalculate the spreadsheet" includes any cell that is manipulated. Thus what I am running into is the Worksheet_calculate() sub procedure is being called over and over until the stack overflows, EVEN though the TEST spreadsheet I am using has only one cell of data that I change and one calculation. Everything else is static. Anyone have ANY suggestions around this problem? Any way to call a sub procedure from the spreadsheet itself? I am using Excel 2003 with all the patches and updates. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Certain methods stop procedure execution without notification | Excel Programming | |||
why does the execution jump to another procedure? | Excel Programming | |||
Time the Execution Speed of Procedure in Milliseconds | Excel Programming | |||
Blank Message Box after procedure execution | Excel Programming | |||
controlling macro execution | Excel Programming |