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