Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions | |||
HOW DO I REFERENCE A CELL FROM THE RESULTS OF TWO WORKSHEETS | Excel Discussion (Misc queries) | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) |