named ranges
 

I got a sample excel worksheet from KYd
http://www.exceluser.com/dash/gauges_no.htm

and in one workbook, they use the same range name on multiple tabs, and when
I
go to tab 1
hit F5
select range name "alpha"
i am taken to a location on tab 1

then I goto tab 2
hit F5
select range name "alpha"
i am taken to a location on tab 2

I try to duplicate thsi and can't?

Any ideas

named ranges
 

UsGrant_75

You can have the same name on muliple sheets if you create the name to
include the sheet name. For example if your first sheet is named
"worksheet1" and your second sheet is called "worksheet2" in the define
names dialog you can create myrange on both by including the sheet name with
your selection ie worksheet2!myrange.

Dave


"UsGrant_75" wrote in message
...
I got a sample excel worksheet from KYd
http://www.exceluser.com/dash/gauges_no.htm

and in one workbook, they use the same range name on multiple tabs, and
when
I
go to tab 1
hit F5
select range name "alpha"
i am taken to a location on tab 1

then I goto tab 2
hit F5
select range name "alpha"
i am taken to a location on tab 2

I try to duplicate thsi and can't?

Any ideas

named ranges
 

Nel post
*UsGrant_75* ha scritto:

I got a sample excel worksheet from KYd
http://www.exceluser.com/dash/gauges_no.htm

and in one workbook, they use the same range name on multiple tabs,
and when I
go to tab 1
hit F5
select range name "alpha"
i am taken to a location on tab 1

then I goto tab 2
hit F5
select range name "alpha"
i am taken to a location on tab 2

I try to duplicate thsi and can't?

Any ideas

To define names on Sheet bases, you have to write also the name of the
sheet, so if you want a name Mouse on Sheet1, go to menu Insert, Name,
Define and in "Names in workbook" type Sheet1!Mouse, then point to Refers to
and choose the range on Sheet1, then click Add, in "Names in workbook" type
Sheet2!Mouse, then point to Refers to and choose the range on Sheet2, then
clic OK.

In this way every time you are in Sheet1 and select the name Mouse will be
selected the range on Sheet1, the same on Sheet2.


--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy