Out of Memory error
I am having a problem running a macro (XL97) and getting an "Out of
Memory" message box. It just gives you an OK option. I click OK, then
it pops up again, click OK. Then a type mismatch error on a line of
code that says....
Erase output
....and output is an array. All I did then was move the cursor down to
the next line of code, hit F5, and it finished running fine. Any idea
what I can do? Thanks!
Keith
PS - Don't know if this is relevant, but that line was in a loop, and
it wasn't the last iteration in the loop, so it hit that line again
and didn't crash.
|