Free Support Forum -

AddCopy and cell names

when i use AddCopy to make a copy of a worksheet it doesn't copy cell names.

how can i get it to do so?


If a defined name is a global name, it isn't copied. If it's a name within a sheet, for example: "Sheet1!Range1", it will be copied.