i was not saying copying the formulas creates a link to the source
workbook.
What i meant is using the method you described can't replicate what
the source workbook
has in the destination workbook.

(meaning: cell D9 = "=A1:A2", cell D10 = "=A1:A2" in destination
workbook, and these formulas
are not array formulas. but cell D9 and D10 in source workbook have an
array formula and
you can't change D9 or D10 individually)

By "copyD9:D10 from source book to D9:D10 in a new workbook", you mean
using select - copy - paste by formula
or your method (EditReplace / What: = / With: ^^^)? If it's your
method, source workbook and destination workbook are not the same.

thanks.

Replace all.

On May 6, 12:11 pm, Gord Dibben <gorddibbATshawDOTca wrote:
When IcopyD9:D10 from source book to D9:D10 in a new workbook, I do not get
the link to the source book.

What copies is {=A1:A2} in D9 and {=A1:A2} in D10

Gord

On Mon, 5 May 2008 18:08:46 -0700 (PDT), MCI wrote:
sorry for any confusion.
the array formula in my post is entered as this:

1. select cells D9 through D10
2. enter the following formula in the formula bar:
=A1:A2
3. Press CTRL+SHIFT+ENTER.

Thanks.