What about using RAnge Names. In Excel 2003 these are file specific in scope in 2007 you can set them Globablly or by sheet. When entering formulae or referring to any area on the spreadsheet, it is usual to refer to a "range". For
example, B6 is a range reference; B6:B10 is also a range reference. A problem with this sort of reference is
that it is not always easy to remember what cells to reference. It may be necessary to write down the
range, or select it, which often means wasting time scrolling around the spreadsheet. Instead, Excel offers
the chance to name ranges on the spreadsheet, and to use these names to select cells, refer to them in
formulae or use them in Database, Chart or Macro commands.
http://www.mousetraining.co.uk/training-manuals/Excel2007Adv.pdf page 5 begins a secion on Range Names