View Single Post
 
Old 11-05-2015, 05:06 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, I thought so ... do you put that sheetname_variable in quotes or something?
I use the code
>>Sheets(v_Sheetname).Activate<<
which doesn't work.
The formatting of the date in a MsgBox is the exact same as on the sheet. Possibly the internal formatting that is used for the variable is different?
How could I control that?
Reply With Quote