Name scope within a workbook

C

Christer

I have 3 different workbooks open. A sheet within one workbook contains a
number of named Ranges. When I copy the sheet into one of the other workbooks
the Named ranges gets a scoop of the whole Workbook but when i copy the same
sheet to the second workbook it only get a Wortsheet scoop. Why?
I hope I have made my self understood.
I am using Office 2007, I don't think I hade the same problem with Office XP.

Regards Christer
 

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

Setting Scope of name ranges to particular worksheet 2
Range Name Scope 4
Deleting all named ranges that have a workbook scope 3
Save workbook without shapes 0
Name of file opened, being viewed 2
Need Help with Macro Security 1
Name Scope 2
Copy worksheet containing names to other workbook w/o problems? 1

Top