|
|
#6
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| error1004, failure, paste |
|
|
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 |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode