I don't believe there is anyway to increase the amount of
memory that Excel regognizes. The only thing I can think
of is to make sure all other applications on your
computer are closed or upgrade the memory in the computer
itself.
If you have the option. Try opening the file and running
the macro from another computer that has more memory.
That might tell you if it is a system problem.
There are a few other things you can try to eliminate
some un-needed files that are using your memory. If you
would like to know those please let me know.
Ed
-----Original Message-----
I am trying to copy a large group of worksheets from one
workbook to another within a macro. Whenever this macro
is run the copy method fails due to insufficient memory.
Is there any way to increase the amount of memory your
available to excel?
.

Thanks for the response. Yes, I would love to know any other ideas you might have that could help me work this out.
-Rob

"Ed P" wrote:

I don't believe there is anyway to increase the amount of
memory that Excel regognizes. The only thing I can think
of is to make sure all other applications on your
computer are closed or upgrade the memory in the computer
itself.
If you have the option. Try opening the file and running
the macro from another computer that has more memory.
That might tell you if it is a system problem.
There are a few other things you can try to eliminate
some un-needed files that are using your memory. If you
would like to know those please let me know.
Ed
-----Original Message-----
I am trying to copy a large group of worksheets from one
workbook to another within a macro. Whenever this macro
is run the copy method fails due to insufficient memory.
Is there any way to increase the amount of memory your
available to excel?
.