Hi all,
I have a code that adds in n number of new worksheets and names it based on cell value. Eventually, I have a summary sheet that will perform lookups to respective sheets using indirect.
The newly created sheet names do not have any spaces in them, but for some reason the references are including single quotes. So Sheet1!B2 becomes 'Sheet1'!B2, despite the fact that "Sheet1" has no spaces.
The issue is that because the sheet names have quotes, using the original cell values (where the sheet name is taken from) will lead to a REF error once I do the indirect lookup.
I could just not use indirect and just copy/paste using vba, or add in a step so that the cell values have quotes around them, but I was curious if anyone has run into this before, and if there is a way to get around this.
Btw, the sheet names are all 4 digit numbers. The original cell values are also stored as numbers, not text, if that makes a difference.
Thank you!
I have a code that adds in n number of new worksheets and names it based on cell value. Eventually, I have a summary sheet that will perform lookups to respective sheets using indirect.
The newly created sheet names do not have any spaces in them, but for some reason the references are including single quotes. So Sheet1!B2 becomes 'Sheet1'!B2, despite the fact that "Sheet1" has no spaces.
The issue is that because the sheet names have quotes, using the original cell values (where the sheet name is taken from) will lead to a REF error once I do the indirect lookup.
I could just not use indirect and just copy/paste using vba, or add in a step so that the cell values have quotes around them, but I was curious if anyone has run into this before, and if there is a way to get around this.
Btw, the sheet names are all 4 digit numbers. The original cell values are also stored as numbers, not text, if that makes a difference.
Thank you!
