How to refer to a variable with BLANKs

macropod · #1 11-05-2015, 02:54 AM

The code I posted can be used just as easily to activate a sheet - just change:
MsgBox Sheets(v_Sheetname).Range("A1").Value
to:
Sheets(v_Sheetname).Range("A1").Activate

As I said, the issue may well be with what your code returns as the date.

Officer_Bierschnitt · #2 11-05-2015, 03:09 AM

Quote:

Originally Posted by macropod

As I said, the issue may well be with what your code returns as the date.

That may well be - and how could I change that?
(if that is the case, your code would not work any better in my instance as it also uses that variable, no?)

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