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