Stop named ranges being copied

  • Thread starter Thread starter bmatheson
  • Start date Start date
B

bmatheson

I want to copy a worksheet from one workbook to another.

But I do not want to copy the named ranges associated with the first
workbook to the second.

How do I prevent named ranges being copied when I move sheets.
 
How do I prevent named ranges being copied when I move sheets.

You can't. A named range is just as much a part of a sheet as anything else.
Delete the name(s) after you copy a sheet.
 
Do as Jim suggests, or copy just the cells of the worksheet to a new, blank worksheet.

HTH,
Bernie
MS Excel MVP
 
Back
Top