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!
|