In Excel a Range has a name You can create a rangePress F5 key on the keyboard to open the Go to command Click on Special &Create from Selection In the Create Names from Selection dialog box, select the checkbox (es) depending on the location of your row/column header
The Vba Guide To Named Ranges Thespreadsheetguru
