View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gizmo63 Gizmo63 is offline
external usenet poster
 
Posts: 43
Default Macro stops for no reason

Odd one this:
Excel seems to be getting sensitive when running macros and going on strike
for no reason:)

A number of my users have had their macros code halt and drop into the VBA
editor as if there is a run time error but with no error message.

A line of code highlights as if in debug mode but there is nothing wrong
with the code. F8 steps to the next line and F5 continues processing with no
problems.

The stop point is inconsistent and the stop at commands vary every time.
There appears to be no reason for these breaks and whilst not catastrophic
they are darn irritating.

References are all OK and everyone here is on the same version with all
service updates.

Does anyone have any ideas?

Cheers

Giz