View Single Post
  #1   Report Post  
JT Spitz
 
Posts: n/a
Default 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.