Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OUT OF STACK SPACE ERROR
I get an error everytime I run this.
I need to find a way to avoid the error but still keep my program running. can anyone help me plz? Dim sngtime sub test() Range("A11").select Application.run "test.xls!sheet1.test" sngtime = timer + 1.5 do while timer < sngtime doevents loop application.run "test.xls!sheet1.test" end sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
OUT OF STACK SPACE ERROR
(Hint) Your code is recursive, and it's going to go straight into an infinite
loop. The code will execute like this... Range("A11").select Application.run "test.xls!sheet1.test" Range("A11").select Application.run "test.xls!sheet1.test" Range("A11").select Application.run "test.xls!sheet1.test" ... ... It will never get beyond those lines. You'll need to rework your code. I'll give you a hint later :) " wrote: I get an error everytime I run this. I need to find a way to avoid the error but still keep my program running. can anyone help me plz? Dim sngtime sub test() Range("A11").select Application.run "test.xls!sheet1.test" sngtime = timer + 1.5 do while timer < sngtime doevents loop application.run "test.xls!sheet1.test" end sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Out of Stack Space error | Excel Discussion (Misc queries) | |||
Out of Stack space - run time error 28 | Excel Discussion (Misc queries) | |||
'Out of stack space' error on SaveAs | Excel Programming | |||
Out of Stack Space error | Excel Programming | |||
Run time error 28: Out of stack space | Excel Programming |