Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / July 2008

Tip: Looking for answers? Try searching our database.

Code interrupted

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mzjamez - 17 Jul 2008 21:20 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.