Excel Err Msg: Can't Copy mR X nC into <Reference>Last reviewed: October 31, 1994Article ID: Q23710 |
SUMMARYYou will receive the error message "Can't copy mR X nC into reference," where "m" is the number of rows referenced in the formula, "n" is the number of columns, and "reference" is the area on the document in which the formula resides, if the following conditions are true:
=Worksheet1!$A$1:$A$2was not entered into two vertical cells (corresponding to the two vertical cells A1 and A2), then the above error message will be received. To enter this formula correctly, do the following:
For more information on array formulas, see pages 10-23 in the "Microsoft Excel Reference" version 2.2 manual. If you are using Excel 1.50, see pages 5-20 in the "Microsoft Excel Arrays, Functions, and Macros" manual.
|
KBCategory: kbother
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |