Working with array equations
 

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?

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?

On Sat, 22 Jan 2005 10:25:01 -0800, "OkieViking"
wrote:

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
turn it back into an array equation.

"OkieViking" wrote...
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