Stop named ranges being copied

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.
 
J

Jim Rech

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.
 
B

Bernie Deitrick

Do as Jim suggests, or copy just the cells of the worksheet to a new, blank worksheet.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Copying range of formulas to anotehr workbook 4
VB Script for Copy Sheet 14
Macro to copy portion of each sheet and paste into the first sheet asa picture 1
Get Name of Sheet to use in Macro 11

Top