Debug error

gbaker · #1 09-28-2016, 11:25 AM

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?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I review, and hopefully debug errors that are flashed by upon hitting "Send/Receive (F9)"?	brucemc777	Outlook	0	03-31-2016 10:57 AM
How to create an error debug message	shilabrow	Excel Programming	1	06-27-2014 07:30 PM
VBA: How to debug.Print enumeration names?	tinfanide	Word VBA	4	01-27-2012 01:41 AM
Debug for macro run through button only when sheet protected	leahca	Excel Programming	0	11-24-2011 04:47 AM
Microsoft Office 2003 winword.exe Debug Error! abnormal prog	elo1bev	Word	0	12-22-2005 10:15 AM