View Full Version : Solved: Apply a Range Name to a second sheet
mdmackillop
02-19-2007, 07:09 AM
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.
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
02-19-2007, 08:32 AM
Malcolm,
when you create the name, prefix the name with the sheet it is appicable to
FitCost!FitType
mdmackillop
02-19-2007, 10:55 AM
Hi Glen,
Couldn't get that to work.
Bob,
Thanks a lot.
Bob Phillips
02-19-2007, 11:36 AM
You might find my paper (http://xldynamic.com/source/xld.Names.html)interesting
mdmackillop
02-19-2007, 12:21 PM
Thanks Bob,
An very useful article.
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
02-20-2007, 04:27 PM
Hi Glen
I've not explored 3D ranges but I'll have a look. Never know when then the need will arise.
Regards
Malcolm
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.