Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Error...OUT OF MEMORY | Excel Discussion (Misc queries) | |||
Out of memory error | Excel Programming | |||
Out of Memory Error | Excel Programming | |||
Out of Memory error | Excel Programming | |||
Out of memory error. | Excel Programming |