|
|
#2
03-10-2017, 11:52 AM
|
|||
|
|||
Your code is errant in the declaration of row1, it should be Long and the Set row1= line should be removed.
What workbook is your code in? Your verbiage says to first copy a value from an open workbook.... I don't see any attempt to do this. The B21 you're using is on the same sheet as you are looking for it in the just opened workbook. 
|
| Tags |
| closed workbook, excel vba, object variable error |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Object Variable or With block variable not set | Raza | Excel Programming | 8 | 01-15-2015 12:19 AM |
| Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge | Berryblue | Mail Merge | 1 | 11-13-2014 05:36 PM |
 Run-time error 91 object variable or with block variable not set
|
JUST ME | Word VBA | 4 | 03-25-2014 06:56 AM |
|
Run-time error '91': Object variable or With block variable not set
|
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
| XML parsing & Object variable not set (Error 91) | tinfanide | Excel Programming | 0 | 12-29-2011 08:43 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode