Because 9 times out of 10, most folks will make a revision, and then
*automatically* hit <Enter, which with this type of formula, will invoke
the error message "cannot change part of an array".
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JMB" wrote in message
...
Not sure why I thought otherwise, but thanks for correcting me.

"RagDyer" wrote:

<<<"you need to select all of the cells before editing the function"

*Not* really so!

You can select *any single* formula cell in the array, revise it, then
simply use CSE to register the *entire* array range.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JMB" wrote in message
...
If the array function is entered in multiple cells (instead of a single
cell), you need to select all of the cells before editing the function.
As
already stated, after editing you must commit w/Cntrl+Shift+Enter

"Barak" wrote:

how I can edit array functions
thank