View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cil9mxm cil9mxm is offline
external usenet poster
 
Posts: 1
Default 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