Copy worksheet with named ranges to new workbook and keep names

S

Sandy

Hello -

I have a worksheet in one work book with a large number of named ranges. I
want to use these named ranges in another workbook.

How do I copy a group of named ranges and paste them into the new worksheet
and still preserve the name definitions in the new worksheet?

Many thanks
sandra
 

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 concatenate ranges into a new document 0
Copy worksheet with named ranges to new workbook and keep names in 1
trying to copy a worksheet containing named ranges to anotherworksheet 1
Reference named range in closed workbook 17
How to get range names to Apply across multiple tabs 1
Linked Named Ranges 2
Copying Worksheets which contain Named Ranges 0
Name Scope 2

Top