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?
thanks
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.
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?
thanks
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.