Thread: How to refer to a variable with BLANKs
View Single Post
 
Old 11-05-2015, 02:18 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
  
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default
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!
Reply With Quote