I have a dynamic named range in a spreadsheet called myRange. The
position of this range in the spreadsheet may change.

How can I refer to the contents of this range named "location" in
another spreadsheet?

Example:

myRange=Data!A1:B2
value1 value2
value3 value4

In a new location, say at Results!B2:C4 I want
value1 value2
value3 value4

Under the condition that next time the range could be
myRange=Data!A5:B7 for example.

I tried cutting the range and paste/special, but it always refers to
the range as cell references in the new sheet.

Ian Staines