Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
I have a workbook that has been running fine for a very long time. Last week I noticed that all of a sudden I am getting an error that states "Code execution has been interrupted". The macro still completes the operation, but the error box comes up. I have not altered the code in any way for quite some time, but this error mysteriously started happening last week seemingly out of the blue. Any clues as to what it could be and fixes for this? Public Sub Print_Visible_Worksheets() Application.ScreenUpdating = False Dim sh As Worksheet Dim arr() As String Dim N As Long Const sStr As String = "Main" For Each sh In ThisWorkbook.Worksheets With sh If .Visible = xlSheetVisible Then If StrComp(.Name, sStr, vbTextCompare) Then N = N + 1 ReDim Preserve arr(1 To N) arr(N) = .Name End If End If End With Next sh With ThisWorkbook .Worksheets(arr).PrintOut .Worksheets(1).Select <-----ERROR IS ON THIS LINE End With Application.ScreenUpdating = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code Execution Has Been Interruptred? | Excel Programming | |||
Code Execution Error | Excel Programming | |||
Macro 'Code execution has been interupted' error after print? | Excel Programming | |||
error: Code Execution has been interrupted | Excel Programming | |||
Execution Error | Excel Programming |