Microsoft Office Forums - View Single Post - How to refer to a variable with BLANKs

Thread: How to refer to a variable with BLANKs

View Single Post

Old

11-05-2015, 05:06 AM

Officer_Bierschnitt Officer_Bierschnitt is offline

Officer_Bierschnitt is offline

Officer_Bierschnitt uses Windows 7 64bit

Windows 7 64bit Officer_Bierschnitt uses Office 2013

Officer_Bierschnitt uses Office 2013

Office 2013

Advanced Beginner

The original poster

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