Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am programming an excel spreadsheet macro that processes columns of
data and auto generates a chart per column. I have read the news group articals specifying that recursive procedure calls or a lot of procedure calls can cause this error. I have a single main procedure that calls 1 procedure that does all of the looping for the coulumns and does not call any other procedures. So this should not be a problem. If I tell the app to do the first 10 columns it works fine. the first 20 columns just fine. But there is a number (somewhere around 30) that the macro just starts erroring out. I'm guessing there is some kind of memory leak. I know it's not a limitation with the excel document size because I can run the app in 10 column increments until I've generated 50 columns with no problems. Does anyone have any suggestions? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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" Macro Error | Excel Discussion (Misc queries) | |||
Out of Stack Space | Excel Programming | |||
Run Time Error "28" - Out of stack space? | Excel Programming |