|
|
|
|
#1
05-06-2013, 12:18 AM
|
||||
|
||||
Perhaps: Code:
Sub Macro4()
Range("SummerCompTable").Range("A1:C1").Copy
With Range("POYCompTable")
.ListObject.ListRows.Add (1)
.Range("A1").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
Hybrid Mode