Gwyneth
A way to do this was shown to me in this group by Tushar Mehta and Harlan
Grove

A search for "Editing Array Formula" in this group should help find the
original

Method I now use:
Select any cell in the Array
press f2 then Ctrl+Shift+ Enter
(you now have the whole array selected)
press f2 then Ctrl+Enter
(this converts the array into individual formula)
you can now delete any cells you wish
now select the new array you want and correct the formula
comit with Ctrl+Shift+Enter

Sounds long winded but does work for me (plus it came v.respected members
of the forum so will not be far wrong)

hth RES