|
|
#2
12-05-2015, 01:33 AM
|
||||
|
||||
You have defined FormulaPasteArea as a range. You are programming in Word so that would make it a Word range, hence the error. Change it to an object reference
Code:
Dim FormulaPasteArea As Object
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Selection (range) in Word or Excel table | NobodysPerfect | Word VBA | 2 | 09-16-2014 12:06 AM |
 Find and Replace using Excel range
|
dmarie123 | Word VBA | 15 | 04-02-2013 07:54 AM |
| Paste special an Excel range into Outlook as an Excel Worksheet | charlesh3 | Excel Programming | 3 | 02-04-2013 04:33 PM |
|
Excel - move with tab through named range
|
mjlaw | Excel | 4 | 03-26-2012 10:40 AM |
| Through VBA, export range from Excel to Word | duugg | Word VBA | 0 | 08-24-2009 07:50 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode