Code interrupted

  • Thread starter Thread starter mzjamez
  • Start date Start date
M

mzjamez

I have the following code and everytime I run it I get a debugger message
that says the code is interrupted. I'm not sure how to correct this. Can
anyone help?

Sub COPY()
'
' COPY macro
'

'select area and clear
Range("C6").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.ClearContents
'select area and copy
Range("A6").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.COPY
'select area and paste special values
Range("C6").Select
ActiveWindow.SmallScroll Down:=-12
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
'select area and copy
Range("A1").Select
Application.CutCopyMode = False
Selection.COPY
'select area and paste special values multiply
Range("C6").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlMultiply, _
SkipBlanks:=False, Transpose:=False
End Sub
 
Look a few posts previous to yours, titled "Alien Abduction of VB: Code
execution has been interrupted". It's about the same problem.

Paul
 
I'm having the same problem and there was never anything installed to cause
this to start happening.

What is really happening and what can fix this bug?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top