Re: Defining Names

[Jerry Meng <jmeng81@HOTMAIL.COM>]

Define name locally. 

Ctrl-F3 gives you the window for named range. 

E.g. in sheet1,
Name in workbook:  Sheet1!Address

In sheet 2, 
Name in workbook:  Sheet2!Address

Etc. 


Jerry 



-----Original Message-----
From: MS Excel General Q & A List [mailto:EXCEL-G@PEACH.EASE.LSOFT.COM] On
Behalf Of Collett, Brian (IM&R)
Sent: Friday, November 21, 2003 12:59 PM
To: EXCEL-G@PEACH.EASE.LSOFT.COM
Subject: Defining Names


Sorry this is a simple question.

I need to define the same Name on mutable sheets.  For example I need to
have the name "Address" define on sheet1 and sheet2.  So when I use
"Address" on sheet1 it refers to the cell on sheet1 and when I use "Address"
on sheet2 it refers to the "Address" on sheet2.



Brian Collett, CFA
Investment Management & Research
Russell
909 A Street
Tacoma, WA 98402
253-594-1715

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info and
archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G

--------------------------------------------------------------------------
The EXCEL-G list is hosted on a Windows NT(TM) machine running L-Soft
international's LISTSERV(R) software.  For subscription/signoff info
and archives, see http://peach.ease.lsoft.com/archives/excel-g.html .
                             COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G