Use PasteSpecial and paste the values

Sheets("Sheet1").Range("A1:B3").copy
Sheets("Sheet2").PasteSpecial _
Paste:=xlPasteValues

"Paul Martin" wrote:

In code, I'm rebuilding various sheets in a workbook by cutting and
pasting the contents of a sheet to a new one, but the local names on a
sheet remain attached to the old sheet (which I want to delete). Is
there a way to make the name attach to the new sheet without looping
through all the names and find the local names?

Thanks in advance

Paul Martin
Melbourne Australia