View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default How to stop VBA in a Loop

I don't really have much on debugging but what I have is at
http://www.mvps.org/dmcritchie/excel...d.htm#problems

Here is Chip Pearson's page
VBA Debugging
http://www.cpearson.com/excel/Debug.htm

--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

wrote in message ...
2003/2007


I realize that the info provided below is vague. Hitting the ESC key does not stop execution.

The loop is to cycle through a range of cells. As each new cell is accessed the loop causes
movement to/from other sheets to collect/parse data.

Therefore, there is much disk accessing and processor usage. Because of this, (I guess) the
keyboard is given low priority.

Bottom line, I would like to break execution to ascertain the area of the Loop.

The only success I have had is Ctrl-Alt-Delete to get Task Manager and then force Excel down.

Any thoughts appreciated,

EagleOne