Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - error message "Code excecution has been interupted"
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA - error message "Code excecution has been interupted"
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 DTHIS www.nickhodge.co.uk "Jeff" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleted the pivot table - continue to get the "overlap" error message | Excel Discussion (Misc queries) | |||
Adding more than 3 cells (2003)produces "0" but no error message | Excel Worksheet Functions | |||
"unable to paste link" Excel error message | Excel Discussion (Misc queries) | |||
excel 2003 "french "always reloads with error message when closin | Excel Discussion (Misc queries) | |||
Error message "Not enough system resources to display completely." | Excel Discussion (Misc queries) |