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?

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").R ange("B5")
''''''''''''''''''

hth
--

steveB

(Remove 'NOSPAM' from email address if contacting me direct)


"Rich Cooper" wrote in message
...
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?

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

In article ,
says...
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?