copy sheet with range names

R

R. Choate

I'm making 2 copies of an existing worksheet within a workbook. The original sheet has lots of range names. Now, when I make my
copies, the range names are screwed up and are referring to the new sheet instead of the original one. What's up with that? I don't
see any options related to range names. Deleting and resetting the names would take forever, as would "re-defining". I shouldn't
have to do that. Any ideas?
 
D

Dave Peterson

I think if you look at your range names, you'll find that xl localized the
copies. When it copied the worksheet, it had to do something with the range
names. Instead of dumping them and possibly breaking lots of stuff on the
worksheet, it made them include the worksheet name in the name of the range.

So if I had a (global) range name of MyData, when I copied that sheet to a new
sheet (say Sheet9), that range name became sheet9!myData.

(If the worksheet contained spaces, the name would have single quotes: 'sheet
9'!myData)

to make your life a lot easier (that Insert|name dialog is pretty difficult to
work with), grab a copy of Jan Karel Pieterse's (with Charles Williams and
Matthew Henson) Name Manager.

You can find it at:
NameManager.Zip from http://www.bmsltd.co.uk/mvp
 
L

L. T. Portella

Dave
Could you help me with the following:


I have one workbook with a summary worksheet and at least 50 more individual
worksheets. Each one of these individual worksheets have many named ranges
and I want some of them to appear on the first summary worksheet. How can I
do that? Thank you
[email protected]
 
D

Dave Peterson

See your other post.

L. T. Portella said:
Dave
Could you help me with the following:

I have one workbook with a summary worksheet and at least 50 more individual
worksheets. Each one of these individual worksheets have many named ranges
and I want some of them to appear on the first summary worksheet. How can I
do that? Thank you
[email protected]
Click to expand...
 
Top