I'm not 100% with you on this. Is you've selected a named range, when you CUT
then PASTE then range, with its name also gets copied.

an alternative would be, in code, to select the range save the name, delete
the name from the sheet, paste and name the data onto the new sheet using the
saved name


"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