Thread: named ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
UsGrant_75
 
Posts: n/a
Default 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