-
Solved: Apply a Range Name to a second sheet
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.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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.
-
Malcolm,
when you create the name, prefix the name with the sheet it is appicable to
FitCost!FitType
-
Hi Glen,
Couldn't get that to work.
Bob,
Thanks a lot.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
You might find my paper interesting
-
Thanks Bob,
An very useful article.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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.
-
Hi Glen
I've not explored 3D ranges but I'll have a look. Never know when then the need will arise.
Regards
Malcolm
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules