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
Paul B. - 17 Jul 2008 21:33 GMT
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 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
[quoted text clipped - 29 lines]
> SkipBlanks:=False, Transpose:=False
> End Sub
jeninOk - 31 Jul 2008 20:50 GMT
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?
> Look a few posts previous to yours, titled "Alien Abduction of VB: Code
> execution has been interrupted". It's about the same problem.
[quoted text clipped - 34 lines]
> > SkipBlanks:=False, Transpose:=False
> > End Sub