Help needed with array functions

[JL]

I've gotten into a maddening endless loop where no matter what I do I get an
error message saying "You cannot change part of an array."

The array formula in question is entered in a 3x3 array. It is supposed to
transpose another 3x3 array. One cell now is victim of my erroneous attempt
to modify it, and I can't do anything at all.

I need help badly!

Thanks.

 

[Frank Kabel]

Hi
if you want to change the cells you first have to select them all (all
9 cells)

 

[JL]

This doesn't help. I know this from the Help file. However, once a cell's
formula has been altered you cannot get to that step.

I don't want to do anything but restore the 9 cells to their original array
formula ao that I can perform other actions without the infernal and
unhelpful error message popping up.

 

[Frank Kabel]

Hi
try to delete them all and re-enter your formula

 

[Dave Peterson]

If I've made changes to the array formula:

While the changes are still in the formula bar, copy that fomula (from the
formula bar)

hit escape
(the formula is back to what it was, but have it copied)

While in any cell in the range that holds the array, hit ctrl-/ (control-slash)
This will select the current array.
Hit delete to clear that range
Paste the new formula in and hit ctrl-shift-enter

(you could also have used:
edit|goto (or ctrl-g or F5)
special
current array

to select that array.

 

[RagDyer]

I always wondered how to "easily" change the *size*, as well as the actual
formula in an array, which you've just showed me.

However Dave, if *only* the formula is to be changed, I just select *any*
cell in the array, revise the formula in that cell, and then just CSE, and
the *entire* existing array is revised.
OR, is that not what the OP asked?
--


Regards,

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

If I've made changes to the array formula:

While the changes are still in the formula bar, copy that fomula (from the
formula bar)

hit escape
(the formula is back to what it was, but have it copied)

While in any cell in the range that holds the array, hit ctrl-/
(control-slash)
This will select the current array.
Hit delete to clear that range
Paste the new formula in and hit ctrl-shift-enter

(you could also have used:
edit|goto (or ctrl-g or F5)
special
current array

to select that array.

 

[Dave Peterson]

Well, maybe I was changing the size <vbg>.

Or maybe I just do things the long roundabout way (more likely).