trying to copy a worksheet containing named ranges to anotherworksheet
 

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

trying to copy a worksheet containing named ranges to anotherworksheet
 

On Dec 3, 10:32*am, cil9mxm wrote:
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

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