"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