trying to copy a worksheet containing named ranges to anotherworksheet

C

cil9mxm

I'm trying to copy a worksheet containing named ranges to another
worksheet w/in the same workbook but it keeps wanting to reference the
name ranges of the first worksheet. Is there anyway to do this
gracefully? I want each copied worksheet to reference it's own named
ranges and all the worksheets need to be w/in the same workbook.

- Mo
 
S

Spiky

I'm trying to copy a worksheet containing named ranges to another
worksheet w/in the same workbook but it keeps wanting to reference the
name ranges of the first worksheet.  Is there anyway to do this
gracefully?  I want each copied worksheet to reference it's own named
ranges and all the worksheets need to be w/in the same workbook.

- Mo
Click to expand...

Copy the Sheet, not the cells. Click-drag the tab while holding down
CTRL to copy the Sheet.
 

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

How to get range names to Apply across multiple tabs 1
Copy worksheet with named ranges to new workbook and keep names 0
How do I have a cell value define a dynamic named range? 15
Named Ranges and Dynamic Formulas 4
Copying Worksheets which contain Named Ranges 0
Delete named ranges in VBA - by scope? 2
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
XL2000 - Linking Named Ranges 1

Top