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"
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.