Changing an array formula in a workbook
When you got the error message "Cannot change part of array" and you need to change the array, do the following:
*Select any cell in the Array
*press f2 then Ctrl+Shift+ Enter (you now have the whole array selected)
----- if we select the whole area & if several arrays, we will have the same formula in all cells------
*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
Tags : Excel
