I have a macro that imports data from another open workbook. It has been running fine until today. Now somewhere inside my nested loops, after several thousand iterations, it simply stops running. There's no error, it just ends.
Another forum suggested that it might be a memory problem, so I tried closing and restarting. I also used a different source workbook to import from. That hasn't worked.
It would help if I knew at what point in the code this occurs. Are there any well-worn tricks or techniques for this?
(While I'm waiting for your answers, I'll try to narrow down what loop it occurs in.)
Thanks.
Bookmarks