We were wondering how to edit an array once it has been set up?
 

We have a transpose array set up for a program sheet. We need to increase the
number of cells it pulls from but we get an error message stating we cannot
change an array. How do you change an array without having to start over?

We were wondering how to edit an array once it has been set up?
 

Click in *any one* of the cells that contain the array formula.

Make your revision(s) ... and hit CSE (<Ctrl <Shift <Enter).

This changes *all* the formulas in the array in a single shot!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kfalcone" wrote in message
...
We have a transpose array set up for a program sheet. We need to increase
the
number of cells it pulls from but we get an error message stating we
cannot
change an array. How do you change an array without having to start over?

We were wondering how to edit an array once it has been set up
 

This works. Thanks so much for the help!

"RagDyer" wrote:

Click in *any one* of the cells that contain the array formula.

Make your revision(s) ... and hit CSE (<Ctrl <Shift <Enter).

This changes *all* the formulas in the array in a single shot!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kfalcone" wrote in message
...
We have a transpose array set up for a program sheet. We need to increase
the
number of cells it pulls from but we get an error message stating we
cannot
change an array. How do you change an array without having to start over?

We were wondering how to edit an array once it has been set up
 

Appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kfalcone" wrote in message
...
This works. Thanks so much for the help!

"RagDyer" wrote:

Click in *any one* of the cells that contain the array formula.

Make your revision(s) ... and hit CSE (<Ctrl <Shift <Enter).

This changes *all* the formulas in the array in a single shot!
--
HTH,

RD


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

--------------------------------------------------------------------------
-
"Kfalcone" wrote in message
...
We have a transpose array set up for a program sheet. We need to
increase
the
number of cells it pulls from but we get an error message stating we
cannot
change an array. How do you change an array without having to start
over?