indirect cell reference using copies of worksheets in same workboo
Whenever I copy a worksheet in the same workbook, I get the name followed by
(#). EG worksheet February copies to a new worksheet named February(2).
When i reference that worksheet name in the indirect function through the
cell I set up for the worksheet name, I get the REF error. Does indirect not
work with parenthesis?
The help screen doesn't really discuss this and all the information I
previously received only mentioned spaces in my worksheet names.
I have already figured out that if I change the name to something like
FebruaryB, it would work, but I would like to find out if this is absolutely
necessary.
Thanks.
|