paste fails error 1004 in VBA Excel 2010

macropod · #1 05-06-2013, 04:12 PM

Try:

Code:

Sub Macro4()
    With Range("POYCompTable")
        .ListObject.ListRows.Add (1)
        Range("SummerCompTable").Range("A1:C1").Copy
        .ListObject.ListRows(1).Range.PasteSpecial
    End With
End Sub

mikec · #2 05-07-2013, 12:19 AM

Thanks for that; I would never have thought of putting a piece of code in the middle of a With loop but when you see it it's obvious enough. What I still do not understand is why the Copy has to be positioned between the Add and the Paste or should I say that the Paste has to be immediately after the Copy; (I tried it and it failed as before.)
If you have time to clarify I will go from very happy to ecstatic.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Paste special an Excel range into Outlook as an Excel Worksheet	charlesh3	Excel Programming	3	02-04-2013 04:33 PM
Outlook 2010 & WM 6.5 - recurring appt fails to sync	ghumdinger	Outlook	1	08-11-2012 02:20 PM
Run time error 1004	yonasan	Excel Programming	3	06-12-2012 11:08 PM
runtime error 1004	gbaker	Excel Programming	11	06-06-2012 05:23 AM
Microsoft office 2010 error 2908 and error 1935 !!!!!!heeeeellpppp!!!!!!!!!	bennypryde	Office	1	01-05-2012 03:33 PM