The information in this article applies to:
SUMMARY
When you enter a formula that is linked to a worksheet whose name begins
with the letter "R" followed by a digit, or any letter followed by a
dollar sign, you must enclose the name in single quotation marks.
MORE INFORMATION
For example, if the worksheet name begins with either R followed by a
number or A followed by a dollar sign (such as R1 or A$), a formula
with links to a supporting sheet must be entered as follows:
If the sheet name begins with an R that is not followed by a number or an A that is not followed by a dollar sign, (including RC or A1), then the above formula can be entered as follows:
Additional query words: 2.0 2.00 2.01 2.1 2.10 3.0 4.0
Keywords : |
Last Reviewed: March 16, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |