| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running out of memory
I'm running a macro which copies and pastes pictures.
It'll only run about 30 times until Windows runs out of memory. I then have to quit Excel and start again. Is there anyway to clear the memory each time so it can run without quiting? Thank you Ian |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running out of memory
Try setting the zoom to 100 (under the view menu).
-- Regards, Tom Ogilvy "Ian Belcher" wrote in message ... I'm running a macro which copies and pastes pictures. It'll only run about 30 times until Windows runs out of memory. I then have to quit Excel and start again. Is there anyway to clear the memory each time so it can run without quiting? Thank you Ian |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running out of memory
Thanks for the reply.
The zoom is set to 100, but I can't understand why this would affect the memory. Ian -----Original Message----- Try setting the zoom to 100 (under the view menu). -- Regards, Tom Ogilvy "Ian Belcher" wrote in message ... I'm running a macro which copies and pastes pictures. It'll only run about 30 times until Windows runs out of memory. I then have to quit Excel and start again. Is there anyway to clear the memory each time so it can run without quiting? Thank you Ian . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running out of memory
I'm having this same exact issue ... and I have 2GB of RAM
in my machine! I think the answer is clearing/emptying the "clipboard." I'll look for an answer and/or will check back here to see if anyone else answers. Dan -----Original Message----- Thanks for the reply. The zoom is set to 100, but I can't understand why this would affect the memory. Ian -----Original Message----- Try setting the zoom to 100 (under the view menu). -- Regards, Tom Ogilvy "Ian Belcher" wrote in message ... I'm running a macro which copies and pastes pictures. It'll only run about 30 times until Windows runs out of memory. I then have to quit Excel and start again. Is there anyway to clear the memory each time so it can run without quiting? Thank you Ian . . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Running out of memory
Emptying your variables after you used them often works in these cases
Some of them (like workbook or worksheet) can take up a lot of memory -- Message posted from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XL 2007 - Out of Memory - memory leak/bug? | Excel Discussion (Misc queries) | |||
| Copy/Paste - Running out of Memory | New Users to Excel | |||
| "Out of memory" when running a Web Query | Excel Programming | |||
| XP running out of memory when using macro | Excel Programming | |||
| Not enough Memory running macro | Excel Programming | |||
![Ian Belcher[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
