excel - How to change size occupied by an array formula? -


i have formula, returns array. possible change range occupied result of formula? (programmatically)

no, it's not possible. have delete array , make new one.

from microsoft support website: you can't delete cells in array formula (you'll see "you cannot change part of array" error), can delete entire formula , start over.

so in order achieve this, first have select cells in array, press delete , type / paste formula again in new range.


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -