copy the range names while coping cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to copy an area from one workbook to another. that area in cludes
cells that have range names.i need a way to copy the range names as well. not
only the formating and the data.
do you know how i could do that?
 
Be careful when you copy named ranges to a new workbook. They do copy over
but they act differently depending on whether it is a sheet level or workbook
level name. You will need to check their references once copied.
 
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
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
Copy Multiple Areas from One Workbook to Another 4
Name the range AFTER copied to new sheet 6
UnSelect the copied to range after copy... 4
Copy value from changing cells without VBA 1
Copy range based on input 1
Scattered array cells copy to scattered array cells another workbook 14

Back
Top