View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
swatsp0p
 
Posts: n/a
Default Insert | Name | Label


In Excel HELP, search for "About labels and names in formulas" for
further information.

Note: By default, Excel does not recognize labels in formulas. To use
labels in formulas, click Options on the Tools menu, and then click the
Calculation tab. Under Workbook options, select the Accept labels in
formulas check box.

Labels are similar to Names, but different. Labels can only be used on
the sheet in which they appear, names can be on any sheet in the
workbook.

HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=555663