Copying sheets without copying named ranges

N

NMACK08

I have a workBOOK with named ranges in it, and want to copy a workSHEET out
of it into a new workBOOK without taking the range names into the new
workBOOK. The new workSHEET doesn't have any named ranges in it, but when I
copy it to a new workBOOK (also without named ranges), it copies all of the
names from the original workBOOK into the new workBOOK.
 
J

JLGWhiz

I would think that:

ActiveWorkbook.ActiveSheet.Cells.Copy
Workbooks(2).Sheets(1).Range("A1").PasteSpecial Paste:=xlPasteValues

Would work.
 

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

Reference named range in closed workbook 23
Delete named ranges in VBA - by scope? 2
Copy worksheet with named ranges to new workbook and keep names in 1
Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... 3
renaming named ranges 4
copy worksheets between workbooks - including named ranges 2
Copy value from changing cells without VBA 1
Using worksheet templates with named ranges 1

Top