Thread: [Solved] Debug error
View Single Post
 
Old 09-28-2016, 11:25 AM
gbaker gbaker is offline Windows 7 32bit Office 2010 32bit
Competent Performer
 
Join Date: May 2012
Posts: 111
gbaker is on a distinguished road
Default Debug error

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?
Reply With Quote