PrintArea and PrintTitles for sheets with spaces in name
Posted: Mon Jan 09, 2017 8:00 am
Hi,
This code fails when trying to set print areas or repeating rows on sheets with spaces in the names.
If the sheet name is "Client Information", I get an error saying E4016: Uknown sheet name "Information"
Is there another way to set internal names where I can specify the sheet name with single quotes to fix this?
Regards,
Carl
This code fails when trying to set print areas or repeating rows on sheets with spaces in the names.
Code: Select all
Sheet.PrintSettings.PrintArea(1, 1, 2, 2);
Is there another way to set internal names where I can specify the sheet name with single quotes to fix this?
Regards,
Carl