How to refer to a variable with BLANKs

Officer_Bierschnitt · #7 11-05-2015, 02:45 AM

Well,

the sheet does exist at the time I run my macro - it is prepared every day before 8 o' clock.
The output of the DATE function is formatted like that, at least it is when I output it in a MsgBox.
You're right, I don't need to activate the sheet, just like I don't need to SELECT cells all the time just to put some values into them. It just makes the code a lot easier to read (for not-savvy others), which is one of my primary development standards.

So, what can I do, or how could I make sure the date is formatted like I need it?

Thanks a lot!

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