View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Keith[_7_] Keith[_7_] is offline
external usenet poster
 
Posts: 15
Default 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.