I am trying to copy a tab which references named ranges in its current workbook to a new workbook with the same named ranges and would like to do so with out the dialog boxes popping up to ask if I want to use the existing named ranges and would like it to reference the ranges in the current spreadhseet not link back to the previous one.
