|
|
|
|
#1
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 
|
|
#3
12-07-2015, 01:51 PM
|
|||
|
|||
|
I changed my code as suggested but it still will not work. When the program executes the next line it gives me the error "application defined or object defined error". when i open the Immediate window and test for the FormulaPasteArea value i get the message "object variable with block variable not set". I don't know what to do to correct this. Could someone help me please?
|
|
|
|
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
Hybrid Mode