Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OFFSET and array formulae | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
What instead of an array formula? | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |