Mega Code Archive
Enter a Named Cell or Range Using the Name Box
Click the Name box list arrow on the formula bar.
Click the name of the cell or range.
The range name appears in the Name box.
All cells included in the range are highlighted on the worksheet.