How to change size occupied by an array formula?

I have a formula, that returns array. Is it possible to change ra开发者_Python百科nge occupied for result of this formula? (programmatically)

no, it's not possible. you have to delete the array and make a new one.

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

so in order to achieve this, you first have to select all the cells in the array, press delete and then type / paste the formula again in a new range.

Take a look at this site from Microsoft.

Scroll down to the section called "Rules for entering and changing array formulas"