| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you refer to a dynamic named range?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make camera object refer to dynamic range | Excel Discussion (Misc queries) | |||
| Refer to a named range indirectly | Excel Worksheet Functions | |||
| Refer to Named Range on another sheet for IF function | Excel Worksheet Functions | |||
| ???Refer to a specifc cell in a named range | Excel Worksheet Functions | |||
| How does one refer to the n-1 element of a named range? | Excel Discussion (Misc queries) | |||
Threaded Mode
