VBA - error message "Code excecution has been interupted"

[Jeff]

Hi,

I am running a macro and I get the error message

"Code excecution has been interupted"

This happens every time I run my macro and it stops in different parts of
the program - for no apparent reason. For example here is where it stopped


Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False 'It stopped here
Selection.NumberFormat = "h:mm:ss AM/PM"
End Sub

I just click on the "run" button and the macro continues without a problem.
Does anyone know what is going on and how to fix this?

Thanks for your help.

 

[Nick Hodge]

Jeff

That line of code simply takes Excel out of cut/copy mode. (Stops the
marching ants). There is no specific reason why the code breaks at that
point.

If you try to interact with Excel while code is running or press the esc key
or if the code you are running triggers a event could all be the cause of
code becoming unstable

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk