Thread
:
Macro stops for no reason
View Single Post
#
3
Posted to microsoft.public.excel.programming
Gizmo63
external usenet poster
Posts: 43
Macro stops for no reason
Nope - no crossovers like that.
The stop point can be anything from:
Application.ScreenUpdating = True
Range("A1").select
Application.Calculation = xlManual
Completely variable both in code and sub, and I have many users using
identical templates and macros usually with no problems at all.
Thanks for trying - next guess!
"Nigel" wrote:
"......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
Reply With Quote
Gizmo63
View Public Profile
Find all posts by Gizmo63