Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Named Range in ANOTHER workbook
hi I have defined many NamedRanges in 2 workbooks. and copying between NamedRange(s) between the 2 workbooks is desired. I have a need to access THOSE NamedRanges from the 3rd book, thus I need some reference method like: wb_s.range("ThisRange") wb_t.range("ThatRange") <do not prefer BOOK.SHEET.RANGE way so that I can do dim A as Variant A = wb_s.range("From") wb_t.range("To")=A if refencing like BOOK.Range(Name) is not feasible, then dim A as Variant wb_s.activate A = range("From") wb_t.activate range("To")=A but this is not clean. Is Book.Range("MyName") possible? Frankie. -- frtklau |
#2
|
|||
|
|||
maybe:
Dim myBook As Workbook Set myBook = Workbooks("book2.xls") myBook.Names("thisrange").RefersToRange.Copy _ Destination:=ActiveSheet.Range("a1") frtklau wrote: hi I have defined many NamedRanges in 2 workbooks. and copying between NamedRange(s) between the 2 workbooks is desired. I have a need to access THOSE NamedRanges from the 3rd book, thus I need some reference method like: wb_s.range("ThisRange") wb_t.range("ThatRange") <do not prefer BOOK.SHEET.RANGE way so that I can do dim A as Variant A = wb_s.range("From") wb_t.range("To")=A if refencing like BOOK.Range(Name) is not feasible, then dim A as Variant wb_s.activate A = range("From") wb_t.activate range("To")=A but this is not clean. Is Book.Range("MyName") possible? Frankie. -- frtklau -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identifying single column within named range | Excel Discussion (Misc queries) | |||
Define a range based on another named range | Excel Worksheet Functions | |||
How do you point to a named range in linked workbooks? | Excel Discussion (Misc queries) | |||
Poor Workbook Performance due to Named Ranges | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |