Hi All,

I'm getting the following error:

Microsoft Visual Basic
Run-Time Error '7':
Out of Memory


What I do not understand is that I have been successfully
running this code for months without problems, and have
not changed anything. I have all other workbooks,
applications, etc. closed. I have re-booted, and so on,
but ...

Any ideas?! TIA

Perhaps you haven't changed your program, but MAYBE you run some other
applications OR SERVICES on your machine?

Check taskmanager (ctrl-shift-esc) to see the running proggies
(and memory consumption)

Or maybe the usedrange on one of your workbooks has been "damaged"
(which can lead to huge memory consumption. Also the filesize would
increase dramatically.= check where ctrl-end leads you..


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


KENNY wrote :

Hi All,

I'm getting the following error:

Microsoft Visual Basic
Run-Time Error '7':
Out of Memory


What I do not understand is that I have been successfully
running this code for months without problems, and have
not changed anything. I have all other workbooks,
applications, etc. closed. I have re-booted, and so on,
but ...

Any ideas?! TIA