Working with array equations

[Guest]

I am working with a table in which each cell contains an array equation.
Whenever I need to make a change, it turns into a major hassle. I can drag
equations with relative refences, but I loose the array portion of the
equation. I then have to go through each cell and hit "shift+ctrl+enter" to
turn it back into an array equation. Is there a way I can select all the
cells in the table and turn them all into array equations in one swoop?

 

[Myrna Larson]

Is there a way I can select all the cells in the table and turn them all into
array equations in one swoop?

No, there isn't. If you select multiple cells, then press CTRL+SHIFT+ENTER,
you should be dealing with a SINGLE array formula that returns MULTIPLE
RESULTS which are to be returned to the selected cells.

I can drag equations with relative refences, but I loose the array
portion of the equation.

You are doing something incorrectly. In the situation you desecribe, I can
drag the fill handle, or select all the cells and use Edit/Fill, and the
result is array formulas in all of the destination cells. This is with Excel
XP (2002). What is it that you are doing differently?

I am working with a table in which each cell contains an array equation.
Whenever I need to make a change, it turns into a major hassle. I then

have to go through each cell and hit "shift+ctrl+enter" to

 

[Harlan Grove]

I am working with a table in which each cell contains an array equation.
Whenever I need to make a change, it turns into a major hassle. I can
drag equations with relative refences, but I loose the array portion of
the equation. I then have to go through each cell and hit
"shift+ctrl+enter" to turn it back into an array equation. Is there a
way I can select all the cells in the table and turn them all into array
equations in one swoop?

Only with a macro. Try


Sub foo()
Dim r As Range
If TypeOf Selection Is Range Then
For Each r In Selection
r.FormulaArray = r.FormulaR1C1
Next r
End If
End Sub