Don't create range names manually — just let Excel do it for you.
- Select any cell in the range and press [Ctrl]+[Shift]+* to select the contiguous range. (There's a great keyboard shortcut you might not know!)
- Choose Name from the Insert menu and then choose Create. If you're using Excel 2007, click the Formulas tab and choose Create From Selection in the Defined Names group.
- Excel will display the Create Names dialog box; it does a good job of finding the label text. Usually, you won't have to change the settings, but you can.
- Click OK.