Run time error 28: Out of stack space
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
|