Range is the group of two or more adjacent or non adjacent cell in a worksheet.
When you define a name that refers to a cell or range of cells in another workbook, you create a link known as an external reference. When you do this procedure, make sure the workbook you want to refer to is open and that it has been saved.

a. In the workbook in which you want to create the external reference, point to Name on the Insert menu, and then click Define.
b. In the Names in workbook box, enter the name for the external reference.
c. If the Refers to box contains a reference, select the equal sign (=) and the reference and press BACKSPACE.
d. Activate the workbook that contains the cell you want to refer to by clicking the name of the workbook on the Window menu.
e. Select the cell or range of cells you want to refer to.
f. In the Define Name dialog box, click Add.