I'm not clear on what you mean. When you say "copy this whole array again",
do you want the formulae in the array to refer to a new absolute reference?

Suppose you anchor the row references only (like A$11), and then copy your
array 4 columns to the right on the same row, then the formulae will change
to E$11.

Tell me if I'm barking up the wrong tree!
--
Richard

Search the web and raise money for charity at http://www.everyclick.com/


"Strd M 37" wrote:

I want to make a spreadsheet where i have a formula that references a cell,
and then be able to copy the formula to other cells, and have the same cell
be referenced, such as using $A$11, but i want to be able to copy this whole
array again without having to move the absolute references, making them like
local "absolute" references. Is this possible?