Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Naming ranges on multiple worksheets
0 views
Skip to first unread message
Jim
Nov 23, 2009, 2:12:03 PM11/23/09
to
I have a workbook with multiple worksheets, the worksheets are structured
identical to each other. I need to name certain ranges in each of the
worksheets. On the first worksheet, I was able to name the ranges without
difficulity, however when I attempt to name the ranges on the worksheet
number 2, it throws me back to sheet 1. The range name that I entered on
sheet 2 was not accepted, the name box is still showing the cell number. Can
anyone assist?
identical to each other. I need to name certain ranges in each of the
worksheets. On the first worksheet, I was able to name the ranges without
difficulity, however when I attempt to name the ranges on the worksheet
number 2, it throws me back to sheet 1. The range name that I entered on
sheet 2 was not accepted, the name box is still showing the cell number. Can
anyone assist?
Using Excel 2003.
Thanks,
Jim
Gord Dibben
Nov 23, 2009, 2:51:52 PM11/23/09
to
One method
On sheet1 Insert>Name>Define MyName
Refers to: =INDIRECT("A1:F20")
Note: won't show up in NameBox or in Edit>Go To or F5
Must be typed into refedit dialog.
Gord Dibben MS Excel MVP
On Mon, 23 Nov 2009 11:12:03 -0800, Jim <J...@discussions.microsoft.com>
wrote:
Dave Peterson
Nov 23, 2009, 3:47:26 PM11/23/09
to
Use local/worksheet level names.
Select the range
and include the sheet name in the namebox when you create the name, like:
'Sheet 99'!myNameHere
--
Dave Peterson
Jim
Nov 23, 2009, 4:08:01 PM11/23/09
to
Thank you.
Jim
"Gord Dibben" wrote:
> .
>
0 new messages