named ranges

U

UsGrant_75

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
 
D

Dave

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
 
F

Franz Verga

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
Click to expand...

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
 
Top