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: 2
Default Error 7 Out of Memory 2/3 through Macro

I have Excel 2002 and running a Macro which puts simple shapes (arrows) and
text in cells to make a presentation. About 2/3 of way through, at the same
point every time, I get the above or another similar error message. This is
happening at the following statement;

arrow4.cut
set arrow4 = nothing

Now, after an arrow and text have been viewed, it is cut and cells reset for
the next display. No problem on the first 3 arrows and 1 pic.

Here is the weird part for me; I put in a statement JUST before this error
that states available memory and it is 200,000 +, then the error! I don't
get it.

Also, after running this more times than I want to count and shutting down
the whole computer and reopening the spreadsheet, when I make a new arrow
and click on its name, it has a name of "Line 107" (of course if I delete it
and make another it is "Line 108", etc.) But it seems to me that if you
shut down the spreadsheet, and especially if I shut down the computer, that
the next time you open that spreadsheet and make a new arrow that the name
should be "Line 1"!

What am I missing here?

Thanks to anyone who can help,
CoderB


 
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
Macro Error...OUT OF MEMORY G118 Excel Discussion (Misc queries) 1 October 15th 05 09:35 PM
Out of memory error Francesco Guiseppe Linguine Excel Programming 4 August 3rd 04 01:49 PM
Out of Memory Error Charlie Tuna Excel Programming 0 November 11th 03 12:28 PM
Out of Memory error Charlie Tuna Excel Programming 0 November 11th 03 12:27 PM
Out of memory error. LHW[_2_] Excel Programming 4 August 27th 03 01:13 PM


All times are GMT +1. The time now is 08:45 PM.

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"