Copy sheet without duplicating named ranges?

[auto.pilot]

Using XL 2007, I often need to copy a sheet within the same workbook, then make several changes to the new sheet. I do this by right clicking on the tab, then selecting 'Move or Copy'. Done this way, all of the named ranges are duplicated for the new sheet, using the same names. The scope changes, but I'd rather do this without duplicating the named ranges. Thoughts?

Thanks

jim

 

[Andrew Poulsom]

You could insert a worksheet then copy/paste the cells.

 

[JoeMo]

Maybe a macro like this:

Sub RemoveNamesAfterCopySheet()
Dim nam As Name

ActiveSheet.Copy after:=ActiveSheet
With ActiveSheet
    For Each nam In .Names
        nam.Delete
    Next nam
End With

End Sub