I have an array function, let's say from B1 to B100.
I want to modify it to be from B1 to B50.
How can I do this without deleting the array and entering the new one?
(I need this because I have array functions in a worksheet and I want to
copy the functions to other similar worksheets where the length of the array
should be different).