"......but there is nothing wrong with the code." I wonder?

The most common cause is when a named range is set to the same as a sub
name.

--

Regards,
Nigel




"Gizmo63" wrote in message
...
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