JT
Note that February (2) contains a space.
Sheetnames with spaces must be surrounded by quotes. That's why your change
to FebruaryB works.....no space.
Try =INDIRECT("'"&K3&"'!F5")
Where K3 contains the sheetname February (2)
Gord Dibben Excel MVP
On Tue, 14 Jun 2005 15:23:02 -0700, "JT Spitz"
<[email protected]> wrote:
>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.
Bookmarks