Macro "Out of memory"

[alexhmmts]

I have a working macro in a work sheet when I try to import or tranfer the
macro to the new wok sheet it give me an out of memory space error. Is there
a way to increse the work space of the new work sheet?

Alex