How to undo macro and check if xl is working or hanged?

C

changeable

Dear All:
How to undo macro and check if xl is working or hanged? I have run som
FOR loop that looks like these:

For i = 1 to 127
For j = 1 to 168
(some autofiltering here based on i and j criteria)
Next j
Next i


However, once i run it, the excel seems to be not responding.

So, will the excel back to respond? and normally what is the acceptabl
time for this kind of job?
Thank
 
Top