|
|
#13
11-05-2015, 05:06 AM
|
|||
|
|||
Well, I thought so ... do you put that sheetname_variable in quotes or something?
I use the code >>Sheets(v_Sheetname).Activate<< which doesn't work. The formatting of the date in a MsgBox is the exact same as on the sheet. Possibly the internal formatting that is used for the variable is different? How could I control that? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Counting Blanks in 1 Column and Non-Blanks in Another
|
dogwood705 | Excel | 4 | 02-07-2015 08:45 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 |
|
object variable or with block variable not set
|
MJP143 | Excel | 1 | 02-11-2013 05:07 AM |
|
Run-time error '91': Object variable or With block variable not set
|
tinfanide | Excel Programming | 2 | 06-10-2012 10:17 AM |
Windows 7 64bit 
Office 2013
Threaded Mode