Is it Possible to Stop a Macro?

  • Thread starter Thread starter John
  • Start date Start date
Thanks Earl, that worked, its been running since 10:00am this morning and
had 18,000 rows to go through - it was only at 7,873, was unsure if I hit
the wrong key the file would become corrupted. Just turned the auto calc
function on/off and it runs in 30 seconds!
 
John,

Good. If your macro doesn't do anything that depends upon results of
calculations in cells, then turning calulation off can really speed things
up. Be sure to turn it back on, or you may have incorrect results in your
formula cells and not realize it.

Also, turning off the screen with Application.ScreenUpdating = False speeds
things up. It's a good idea for the macro to periodically put something on
the screen so it doesn't appear hung. Something like:
Application.StatusBar = RecordNumber.

Chip Pearson www.cpearson.com has a nice progress bar you can use if you
want to get a little fancier.
 
Back
Top