Microsoft KB Archive/192875

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

Article ID: 192875

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q192875





SYMPTOMS
In Microsoft Excel, you may receive the 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 "X" button in the formula bar (or press ESC).

To determine which cells make up the array, use either of the following methods to highlight the range that makes up the array formula:  Choose one of the cells that you know is in the array formula. Then, follow these steps:

 On the Edit menu, click Go To. Or, press F5. In the Go To dialog box, click Special. In the Go To Special dialog box, click Current Array, and then click OK.

-or- Press CONTROL+SHIFT and double-click a cell that you know makes up that array. After selecting the entire range that contains the array formula, edit the formula and press COMMAND+RETURN to reenter the array formula.</li></ul>

Additional query words: XL98

Keywords: kberrmsg kbprb KB192875

-

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

© Microsoft Corporation. All rights reserved.