Macro code interruption error

January 22, 2016 at 07:06:55
Specs: Windows 7
Why Does this macro not work? I am getting code interruption error


Application.EnableCancelKey = xlDisabled

Columns("D:D").Select
Selection.Copy
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4

See More: Macro code interruption error

Report •


#1
January 22, 2016 at 07:26:44
Can you tell us what you are trying to achieve? Without knowing that we cannot tell you why your attempted isnt yielding the result you want

Report •

#2
January 22, 2016 at 07:35:56
I have a macro that I have used in the past with no difficulty. Now I am getting the error message:

Code execution has been interrupted, I have to keep hitting the continue button to keep the macro running:

I found the following answer that should stop the interruption:

Application.EnableCancelKey = xlDisabled

However, now I get a Syntax error?

can you help


Report •

#3
January 22, 2016 at 07:38:56
It seems to be working for me now. Thank you

Report •

Related Solutions

#4
January 22, 2016 at 07:41:07
Does it allow you to hit the debug button when it errors? It should highlight the offending code, can you paste that here?

Do you have any breaks applied that will hault the code?


Report •


Ask Question