ReportDate contains the date serial number for 1/1/2006. And
Company contains text. In both these examples, it probably would
make more sense to set up cells in the workbook to contain these
two values. But that's not the point. The point is that Excel
isn't limited to naming ranges in a worksheet; Excel also can
name text and numeric values. Names also can name formulas,
which can return values. To illustrate, you could define: Here,
the name MyPayment defines a formula that relies on other names
to return a payment amount. Those other names could refer to
cells in a spreadsheet or they could contain the actual values.
Excel Workbook Names That Return References Most Excel names and
definitions look something like this: These Excel names have a
workbook scope. You can use them in any worksheet in your
workbook. To illustrate you could use these formulas anywhere in
your workbook: These names reference specific ranges. Therefore,
when you insert or delete rows above these ranges, or columns to
the left of the