I'm using code that returns the name of a worksheet (strSheetName) from different "sources", depending on the particular procedure. The two methods being used are:
Typically, the results look like:
But if there is a space character in the worksheet name, the results returned appear like:
=<font color=red>'</font color=red>Quotes Submitted<font color=red>'</font color=red>!R2C1:R5C23
It's not possible to apply a method that can consistently extract or reuse the returned sheetnames, without me using two functions to run the returned values through - one to add single quote marks around strSheetName if they're needed in the particular context but they're not already there; the other to remove them from strSheetName if they're present, and if their removal is appropriate to some other context in which strSheetName is being used.
This does work, but it's a bit clunky and rather tedious to have to keep applying these functions throughout the code, in various contexts. Has anyone encountered this and come up with a way to consistently obtain a return value of a sheet name, regardless of whether it contains blanks or not?