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....