Re: Convert Array Formulas to Regular Formulas

  • Thread starter Thread starter minyeh
  • Start date Start date
M

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.

JLatham said:
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.
Click to expand...
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.
Click to expand...
"Domenick" wrote:
Click to expand...
Click to expand...

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.
 
Back
Top