Excel: 'To_reference' Cannot be Enlarged Multiple of 'From_ref

 Last reviewed: November 10, 1994
Article ID: Q89716
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0

SUMMARY

The "Microsoft Excel Function Reference," version 4.0, states that for the "to_reference" in the CUT() command, the reference can "...be a single cell or an enlarged multiple of from_reference. For example, if from_reference is a 2 by 4 rectangle, to_reference can be a 4 by 8 rectangle." However, specifying a reference that is an enlarged multiple of the "from_reference" results in the error, "Cut and paste areas are different shapes."

MORE INFORMATION

When cutting and pasting data or using the CUT() function, the selected destination must be a single cell or a range of cells exactly the same size and shape as the source. Using an enlarged multiple of cells only works when copying and pasting data or using the COPY() function.

REFERENCES

"Microsoft Excel Function Reference," version 4.0, page 89

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 4.0 4.00 documentation error docerr

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 10, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.