O
oldjay
Error -2147417848 (&H80010108): The object invoked has disconnected from its
clients. when I run this macro the second time
Option Explicit
Private Sub CommandButton4_Click() 'Recall 0Master7
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\Quotes\0Master7.xls"
Range("A1:H267").Select
Selection.Copy
Windows("Master7.xlsm").Activate Fail at this line
I added the Option Explicit per MS info but it didn't help
clients. when I run this macro the second time
Option Explicit
Private Sub CommandButton4_Click() 'Recall 0Master7
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Workbooks.Open Filename:="C:\Quotes\0Master7.xls"
Range("A1:H267").Select
Selection.Copy
Windows("Master7.xlsm").Activate Fail at this line
I added the Option Explicit per MS info but it didn't help