Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
list of named ranges
can I export a list of defined ranges from 1 workbook to another ?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
list of named ranges
Not easily. You could write a macro to do it but that might be more work than
it is worth... The Name Manager download might make the task a bit easier.... http://www.oaltd.co.uk/MVP/ -- HTH... Jim Thomlinson "rolando" wrote: can I export a list of defined ranges from 1 workbook to another ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
list of named ranges
If you mean Named ranges, then if we have an active workbook with named
ranges and another open workbook called Book2: Sub qwerty() Dim n As Name For Each n In ActiveWorkbook.Names t1 = n.Name t2 = n.RefersTo Workbooks("Book2").Names.Add Name:=t1, RefersTo:=t2 Next End Sub This will only work if the sheet names are the same in both workbooks -- Gary''s Student - gsnu200811 "rolando" wrote: can I export a list of defined ranges from 1 workbook to another ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
list of named ranges
thanx
this macro works with slight modifications to the ranges regards roland "Gary''s Student" wrote: If you mean Named ranges, then if we have an active workbook with named ranges and another open workbook called Book2: Sub qwerty() Dim n As Name For Each n In ActiveWorkbook.Names t1 = n.Name t2 = n.RefersTo Workbooks("Book2").Names.Add Name:=t1, RefersTo:=t2 Next End Sub This will only work if the sheet names are the same in both workbooks -- Gary''s Student - gsnu200811 "rolando" wrote: can I export a list of defined ranges from 1 workbook to another ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named ranges dissapear from list | Excel Discussion (Misc queries) | |||
Create list of Named Ranges | Excel Worksheet Functions | |||
Named Ranges don't show up in drop-down list | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Viewing List of Named Ranges | Excel Discussion (Misc queries) |