LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Out of Stack Space error TheMilkGuy Excel Discussion (Misc queries) 2 July 22nd 09 05:54 PM
Out of Stack space - run time error 28 Rob Excel Discussion (Misc queries) 2 December 17th 07 04:55 PM
"Out of Stack Space" Macro Error Adam Excel Discussion (Misc queries) 3 July 2nd 07 07:10 PM
Out of Stack Space Michael Smith Excel Programming 2 February 4th 04 04:54 PM
Run Time Error "28" - Out of stack space? Tom Ogilvy Excel Programming 0 September 12th 03 04:43 PM


All times are GMT +1. The time now is 05:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"