Solved: Apply a Range Name to a second sheet

[mdmackillop]

I made a copy of a worksheet which contained a RangeName "FitType". This refers to the same range of cells on both sheets, depending upon which sheet is active. I want to add a new range name to both sheets for a second set of cells, but my efforts are overwriting the previous version. So how to do this?
The image shows the duplicate name, identifying its current location.

[moa]

Not sure if I understand the question but...

I think you just hold down shift and click on the second tab then,on the first (open) tab, select the group of cells that you want.

[Bob Phillips]

Malcolm,

when you create the name, prefix the name with the sheet it is appicable to

FitCost!FitType

[mdmackillop]

Hi Glen,
Couldn't get that to work.

Bob,
Thanks a lot.

[Bob Phillips]

You might find my paper (http://xldynamic.com/source/xld.Names.html)interesting

[mdmackillop]

Thanks Bob,
An very useful article.

[moa]

If you just wanted to make a 3D named range you type in something like ='Sheet1:Sheet2'!A$1:A$20, which is what comes up when you do what I was trying to say in my first post.

Sounds like you maybe wanted something else though.

[mdmackillop]

Hi Glen
I've not explored 3D ranges but I'll have a look. Never know when then the need will arise.
Regards
Malcolm