Copied sheet causing duplicate range name error (Excel 2010)

J

jgeniti

I have a procedure that copies an array of worksheets from my main
workbook into a blank workbook. What I noticed when I started testing
this in Excel 2010 (from 2003), one of the pages is trying to copy
over range names and I'm getting the duplicate range name error
message. It was my understanding that by default, the range names
would not be brought in by default. This is true for the other 10
sheets that are being copied. Does anyone have any ideas or ways to
force that no range name be brought over?

Thank you
 

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

Duplicate name range error when copying sheet (Excel 2010) 4
Name the range AFTER copied to new sheet 6
Import Excel 2010 table into Access 2010 - not listed as range 0
Make the Name Box wider? 4
images into excel 0
Excel 2010 Sendmail .Display works, but not .Send --- Please help 2
shorten sheet name 4
Problem tabbing between merged cells in Excel 2010 0

Top