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