Define Local Name using Name Box

  • 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 Box on the left-hand side of the formula bar,
rather than Insert | Name | Define from the menu.

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

Thanks for your help.
Chris S.
 
Just include the sheet name in the name box:

Sheet2!SheetName

note that SheetName will still be a workbook-level name unless you
redefine it.
 
This does not seem to work if the name has already been
defined on another worksheet. When I type

Blue!SheetName

Excel takes me to the "Red" sheet and the original name
definition.

More help please.

Chris S.
 
My mistake - you can use that if you're in Insert/Name/Define, but
not with the name box if a workbook-level name is defined.

Use Insert/Name/Define to delete the workbook level name, then use
the namebox for the sheetx!sheetname.
 
Back
Top