Mega Code Archive
Let Excel Name a Cell or Range
Select the cells, including the column or row header.
Click the Formulas tab. Click the Create from Selection button.
Select the position of the labels in relation to the cells.
Click OK. And check the new name in the name box.