Macro "out of Memory"
 

I have a macro that works in a previous worksheet and tryed to transfer it to
a new worksheet. I used the method of draging it to the VBA work space of the
new worksheet and importing it. In both cases I receive an ont of memory
error. Is there a way that i can incresae the usable space for the macro?

Macro "out of Memory"
 

The code taken up for a macro shouldn't be much.
Try moving the macro into a new workbook using a new method e.g create
a workbook - add a blank module - and copy-paste the code into the
blank module.

J


On 18 Sep, 07:07, alexhmmts
wrote:
I have a macro that works in a previous worksheet and tryed to transfer it to
a new worksheet. I used the method of draging it to the VBA work space of the
new worksheet and importing it. In both cases I receive an ont of memory
error. Is there a way that i can incresae the usable space for the macro?

Macro "out of Memory"
 

I moved the code and now get the error "424"

Thank you

"WhytheQ" wrote:

The code taken up for a macro shouldn't be much.
Try moving the macro into a new workbook using a new method e.g create
a workbook - add a blank module - and copy-paste the code into the
blank module.

J


On 18 Sep, 07:07, alexhmmts
wrote:
I have a macro that works in a previous worksheet and tryed to transfer it to
a new worksheet. I used the method of draging it to the VBA work space of the
new worksheet and importing it. In both cases I receive an ont of memory
error. Is there a way that i can incresae the usable space for the macro?

Macro "out of Memory"
 

Can i see the code please.

J

On 18 Sep, 16:24, alexhmmts
wrote:
I moved the code and now get the error "424"

Thank you



"WhytheQ" wrote:
The code taken up for a macro shouldn't be much.
Try moving the macro into a new workbook using a new method e.g create
a workbook - add a blank module - and copy-paste the code into the
blank module.

J

On 18 Sep, 07:07, alexhmmts
wrote:
I have a macro that works in a previous worksheet and tryed to transfer it to
a new worksheet. I used the method of draging it to the VBA work space of the
new worksheet and importing it. In both cases I receive an ont of memory
error. Is there a way that i can incresae the usable space for the macro?- Hide quoted text -

- Show quoted text -