Range Names

  • Thread starter Thread starter Rich Cooper
  • Start date Start date
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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Named ranges and pasting formulas with named references 2
Copy worksheet with named ranges to new workbook and keep names in 1
Cell values to an array, then array transpose to another workbook 8
Resizing range 1
Copy value from changing cells without VBA 1
InputBox to name a range 2
UnSelect the copied to range after copy... 4

Back
Top