Let us say I have a named range TEST which refers to sheet1 and covers Range
A1:D10

If I go into another sheet, select A1:D10 (exact same area/location, but in
another sheet), go to the formula bar and enter =TEST and hit CTRL + Enter,
then it does link to the respective cells.

If I go to another part of the sheet and select a comparable area, I need to
do an Array entry

=TEST CTrl+Shift+Enter

and it will work.

--
Regards,
Tom Ogilvy


"Joanne" wrote:

using excel 2003

Can excel link worksheets by an entire named range on each ws instead of
setting up cell to cell links?

Thanks for the info
Joanne