Microsoft KB Archive/89716

{|
 * width="100%"|

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

 * }

-

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 &quot;Microsoft Excel Function Reference,&quot; version 4.0, states that for the &quot;to_reference&quot; in the CUT command, the reference can &quot;...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.&quot; However, specifying a reference that is an enlarged multiple of the &quot;from_reference&quot; results in the error, &quot;Cut and paste areas are different shapes.&quot;

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.