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