Re: Convert Array Formulas to Regular Formulas

[minyeh]

When I manually correct these spreadsheets, I have to select all the cells
that have the array formulas and DELETE them before I can go ahead and paste
in the regular formulas from another workbook. Is there some way to modify
your code to do this so that I don't get the "Cannot change part of an array"
error?

Thanks.

I meant to confirm that the {} you are seeing in array formulas are placed
there by Excel.  They are placed there when you commit a formula using
[Ctrl]+[Shift]+[Enter] rather than by the normal [Enter] key.  So you're
right, in a fashion they don't really exist; kind of like the $ symbol when
you format a cell as currency - you didn't put it there, Excel did.

Any editing of an array formula requires that you again commit it by using
the 3-key combination, but if you just hit [Enter] it turns into a non-array
formula.

"Domenick" wrote:

select any one cell within the array formula, press F2 to edit, press
CTRL+SHIFT+ENTER, this will help u to select all the cells within the
array formula,
then press F2 again, press CTRL+ENTER, this will split the array
formula into standard formula in each cell.
this might be what u'r looking for.