If I have an array which is referred to by many cells, is there a way to
change all the dependant cells to refer to another array of equal size,
without going through each dependant column individually, changing the top
cell then copying down. An easy way is just to change the values in the
referenced array, but I want to avoid that if possible.

Hope that makes sense....

Yes. The simplest way is to use defined names.. For example if you have many
formulae that refer to A1:A15, then, using:

Insert Name Define

give it a name like stuff. Then your formulae can be re-configured from
=SUM(A1:A15) to
=SUM(stuff)

at any point all you have to do is change the definition of stuff to
include,say, B1:B15 to do an update without re-editting the formulae
themselves

--
Gary''s Student


"rmellison" wrote:

If I have an array which is referred to by many cells, is there a way to
change all the dependant cells to refer to another array of equal size,
without going through each dependant column individually, changing the top
cell then copying down. An easy way is just to change the values in the
referenced array, but I want to avoid that if possible.

Hope that makes sense....

Good stuff. Thanks for your help!

"Gary''s Student" wrote:

Yes. The simplest way is to use defined names.. For example if you have many
formulae that refer to A1:A15, then, using:

Insert Name Define

give it a name like stuff. Then your formulae can be re-configured from
=SUM(A1:A15) to
=SUM(stuff)

at any point all you have to do is change the definition of stuff to
include,say, B1:B15 to do an update without re-editting the formulae
themselves

--
Gary''s Student


"rmellison" wrote:

If I have an array which is referred to by many cells, is there a way to
change all the dependant cells to refer to another array of equal size,
without going through each dependant column individually, changing the top
cell then copying down. An easy way is just to change the values in the
referenced array, but I want to avoid that if possible.

Hope that makes sense....