Microsoft KB Archive/214054

= XL2000: "Cannot Change Part of an Array" Error Message =

Article ID: 214054

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214054





SYMPTOMS
In Microsoft Excel, you may receive the following error message

Cannot change part of an array

when you attempt to edit one of the cells that make up an array formula.



WORKAROUND
To cancel the error message, click OK, and then click the Cancel (X) button on the Formula Bar, or press ESCAPE.



MORE INFORMATION
To determine which cells make up the array, use either of the following methods to highlight the range that makes up the array formula.

Method 1

 * 1) Select one of the cells that is in the array formula, and then on the Edit menu, click Go To.
 * 2) In the Go To dialog box, click Special.
 * 3) In the Go To Special dialog box, click to select the Current array check box, and then click OK.

Method 2
Press CTRL+SHIFT and double-click any cell that is part of the array.

NOTE: After selecting the entire range that contains the array formula, you can edit the formula and press CTRL+SHIFT+ENTER to re-enter the array formula.

Keywords: kberrmsg kbprb KB214054

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.