I'm getting a debug error in the following code:Selection.PasteSpecial line
HTML Code:
Sheets("Master").Select
Columns("A:O").Select
Selection.Copy
Workbooks.Open Filename:= _
"https://sharepoint.fngn.com/departments/ced/CommunicationsDelivery/PrintProd/Reports%20Library/MasterTableDBase2016.xlsx" _
, UpdateLinks:=3
Sheets("Master").Select
Columns("A:O").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveWorkbook.Save
ActiveWindow.Close
Application.CutCopyMode = False
Does anyone know how to fix this?