R
Roger H.
Hello.I have a macro that runs in a loop fashion from
within Excel.The spreadsheet generates a few thousand
random numbers in a column and then finds a specific
number from within that column.It then generates another
column of numbers and finds that same specific number that
I designate. As this is a macro, it does this many, many
times until the sought after number is NOT found.At that
time, I get a message saying that the data could not be
found ( thus cutting off the macro).That is both what I
expect and want to happen.
The actual problem is that I keep getting an error
message( which stops the macro) from Windows XP saying
that I am low on virtual memory and that it is increasing
the size of my paging file.Fine. I have also manually
increased my paging file size but still keep getting these
error messages that disrupts my macro. This very same file
ran perfectly well on Windows 98, with much less RAM
memory ( 64 megs.../256 megs) What else might I do to fix
this? Thank you. Roger H.
within Excel.The spreadsheet generates a few thousand
random numbers in a column and then finds a specific
number from within that column.It then generates another
column of numbers and finds that same specific number that
I designate. As this is a macro, it does this many, many
times until the sought after number is NOT found.At that
time, I get a message saying that the data could not be
found ( thus cutting off the macro).That is both what I
expect and want to happen.
The actual problem is that I keep getting an error
message( which stops the macro) from Windows XP saying
that I am low on virtual memory and that it is increasing
the size of my paging file.Fine. I have also manually
increased my paging file size but still keep getting these
error messages that disrupts my macro. This very same file
ran perfectly well on Windows 98, with much less RAM
memory ( 64 megs.../256 megs) What else might I do to fix
this? Thank you. Roger H.