Macro Stops without reason

  • Thread starter Thread starter ch
  • Start date Start date
C

ch

Hi All,

I have a macro which after executing some instruction, stops at certain
line. This did not happen initially. And when it does, it usually stops on
the same line of Macro code.

I did not hit the ctrl-Pause key (or ctrl -break), not even touch the
keyboard.

Please help. Thanks.
 
hidoes that mean it stops on other lines at time?????

post your code for evaluation. highlight the problem line(s).

regards
FSt1
 
FWIW, I've seen the same thing intermittently and I can continue execution
with no errors.
 
Are you opening another workbook?
Are you running the macro using a shortcut key?

If yes to both, then remove the shift from the shortcut key combination.
 
The codes will not reveal much.

Problem is intermittent. It has stopped happening now.
When it does stops, it has no error code or comment. I just key F5 to
continue execute the rest of the codes.

Barb (see below) has the same problem.
 
The codes will not reveal much.

Problem is intermittent. It has stopped happening now.
When code does stops, it has no error code or comment. I just key F5 to
continue execute the rest of the codes.

Barb (see below) has the same problem.
 
Thanks for feedback.

I think this could be a bug' inherent to Excel. I do not get real problems
besides the inconvenience for the need to manually key "F5" to continue the
program.
 
Back
Top