Are you looking for the syntax
or (across workbooks) perhaps this syntax![]()
Range("MyNamedRange").Copy Destination:= Range("MyOtherNamedRange")
![]()
Dim SourceRange as Range Dim DestinationRange as Range Set SourceRange = Workbooks("Workbook1.xlsm").Names("ANamedRange").RefersToRange Set DestinationRange = Workbooks("Workbook2.xlsx").Names("BNamedRange").RefersToRange SourceRange.Copy Destination:=DestinationRange
Bookmarks