R
rolando
can I export a list of defined ranges from 1 workbook to another ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jim Thomlinson
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/
it is worth...
The Name Manager download might make the task a bit easier....
http://www.oaltd.co.uk/MVP/
G
Gary''s Student
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
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
R
rolando
thanx
this macro works with slight modifications to the ranges
regards
roland
this macro works with slight modifications to the ranges
regards
roland