Memory Problems

[dognz]

I am having Memory overload problems.

I am running a long macro process that transfers a lot of data into a consolidated workbook which involves alot of copying & pasting. Using "application.CutCopymode=false" clears the Excel clipboard of the copy data but does not effect the system memory.

Does anyone have any advise on this problem?

 

[Chris Davison]

On 2002-02-27 02:22, dognz wrote:
I am having Memory overload problems.

I am running a long macro process that transfers a lot of data into a consolidated workbook which involves alot of copying & pasting. Using "application.CutCopymode=false" clears the Excel clipboard of the copy data but does not effect the system memory.

Does anyone have any advise on this problem?

Gidday Dognz,

what's your free disk space there mate ? My very limited non-technical understanding is that if RAM is used up you need free disk space that can be utilised as temporary RAM....

I notice performance degeneration when I have less than 100 megs free

 

[dognz]

i have just under 250mb of free space - I might try and free up a bit to see if performace improces.

Cheers,

dognz

 

[Guest]

Also, still on the same theme, have a look at how your machine is set up to handle virtual memory

start
settings
control panel
system
performance
virtual memory

if, for arguement's sake, you have it set to manual *and* at a level of 20megs, you're in for big trouble and are probably seeing this now with your clipboard problems...

mine's usually set to "let windows decide"

to be honest though, I'm just guessing

HTH
Chris