Range Names

R

Rich Cooper

It is possible to define a range in one work book then copy it and paste it
into another work book without having to redefine the range?
 
S

steveB

Rich,

The following will copy and paste from one book to another. Just substitute
the correct names for the workbooks, worksheets, and range name.

Note that there is no select instruction needed.

'''''''''''''''''
Workbooks("MyBook1.xls").Sheets("MySheet1").Range("MyRange").Copy _
Destination:=Workbooks("Book2").Sheets("Sheet1").Range("B5")
''''''''''''''''''

hth
 
T

Tushar Mehta

Create a new worksheet. Use Insert | Name > Paste... | Paste List
button to get all the names into that worksheet starting with cell A1.
Move the worksheet over to the new workbook. Use the code I posted in
the discussion at http://www.mrexcel.com/board2/viewtopic.php?p=431798#
431798 to create the names in the new workbook.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top