What is Named Range in Excel ?

Ans : 

☞ Creating a named range allows you to refer to a cell or group of cells with a custom name instead of the usual column/row reference. 

☞ The HUGE benefit to using Named Ranges is it adds the ability to describe the data inside your cells. 

 ✅ 1) Creating Unique Names On The Fly : 

☞ It is super easy to create a Named Range. 

☞ All you have to do is highlight the cell(s) you want to reference and give it a name in the Name Box You name cannot have any spaces in it, so if you need to separate words you can either capitalize the beginning of each new word or use an underscore (_). 

☞ Make sure you hit the ENTER key after you have finished typing the name to confirm the creation of the Named Range. 

☞ As a side note, any Named Range created with the Name Box has a Workbook scope. This means the named range can be accessed by any worksheet in your Excel file. 

 ✅ 2) Creating Names With The "Name Manager" :

☞ If you want to customize your named ranges even more, you can open up the Name Manager 

( Formulas tab ➩ Defined Names group ➩ Name Manager button) to edit and create new named ranges. 

 ⚝ With the Name Manager We Can Do : 

 ➀ Change the name of an existing Named Range 

 ➁ Change the reference formula 

 ➂ Specify the scope (what worksheets the name can be accessed from) 

 ✅ 3) Create Named Ranges using VBA Code 

Sub NamedRange() 
Dim Rng As Range 
Dim WB As WorkBook 

Set WB = Application.ThisWorkbook 
Set Rng = Range("A2:A7") 

WB.Names.Add Name:="MyRng", RefersTo:=Rng 
End Sub