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-04-2015, 07:27 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

How to refer to a variable with BLANKs

Hi,

I simply want to activate a worksheet in a file I already have open.
The sheet_name has a BLANK, however, so just putting the variable_name holding the sheet_name in brackets causes an error.
What to do here?

Thanks a lot!

Best regards,

DataNibbler

Reply With Quote