Define Local Name

  • Thread starter Thread starter Chris S.
  • Start date Start date
C

Chris S.

I have an Excel 97 file example with sheets "Red"
and "Blue". In cell Red:A1 the range name "SheetName" has
been defined. I would like to define the same range
name "SheetName" in cell Blue:B1 as a local name, using
the name entry option on the left-hand side of the formula
bar.

I have seen the syntax previously on this, and have
forgotten the procedure.

Thanks for your help.
Chris S.
 
You can do this:
Select that sheet and cell (blue!b1)
Insert|Name|Define

In the name box, include the worksheetname:

Blue!SheetName

you'll need single quotes if you have spaces:
'light blue'!sheetname

(and I'd go back to the first worksheet and make that a local name, too.)

And not that you asked, but if you're working with names, you'll want Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) utility

You can find it at:
NameManager.Zip from http://www.bmsltd.co.uk/mvp
 
Thanks for the reminder. I would also like the syntax for
defining a local name via the Name Box next to the Address
Bar. In other words how can I define a local name without
having to select Insert Name Define ?

Chris S.
 
Try selecting your range and typing the name that you like in the namebox.

Be sure to include the worksheet name, too:

The syntax looks frightenly familiar:
Blue!SheetName
or
'light blue'!sheetname

And another useful (I think) tool that makes life easier if you're using the
name box:

Robert Gelb's NameBoxResizer:
http://www.vbrad.com/pf.asp?p=Source/src_xl_nb_addin.htm
(for xl2k and above, but there's a link that points to an xl97 version)

or if you just want to add it to your own personal.xl* file, you could use code
from Chip Pearson's site:
http://www.cpearson.com/excel/NameBox.htm
 
Back
Top