How to refer to a variable with BLANKs

		Microsoft Office Forums > Microsoft Excel > Excel Programming
How to refer to a variable with BLANKs

FAQ

Thread Tools

Display Modes

11-05-2015, 02:18 AM

Officer_Bierschnitt Officer_Bierschnitt is offline

Windows 7 64bit How to refer to a variable with BLANKs

Office 2013

Advanced Beginner

Join Date: Oct 2015

Posts: 87

Officer_Bierschnitt is on a distinguished road

Well, the code in that place is the following

----------------------------------------
'v_Sheetname = "Data Input " & Date
'Sheets(v_Sheetname).Activate
'-----------------------------------------

The name of the sheet is like >>Data Input 04.11.2015<<.
The objective of that code is to activate the sheet with today's date, which holds yesterday's data.
The second line (with the Activate keyword) is underlined when the error occurs.

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