Tutorial by Examples

Using named ranges allows you to describe the meaning of a cell(s) contents and use this defined name in place of an actual cell address. For example, formula =A5*B5 can be replaced with =Width*Height to make the formula much easier to read and understand. To define a new named range, select cell ...

Create new named range called ‘MyRange’ assigned to cell A1 ThisWorkbook.Names.Add Name:="MyRange", _ RefersTo:=Worksheets("Sheet1").Range("A1") Delete defined named range by name ThisWorkbook.Names("MyRange").Delete Access Named Range by name...

Formulas tab > Defined Names group > Name Manager button Named Manager allows you to: Create or change name Create or change cell reference Create or change scope Delete existing named range Named Manager provides a useful quick look for broken links.

Example sheet Code Sub Example() Dim wks As Worksheet Set wks = ThisWorkbook.Worksheets("Sheet1") Dim units As Range Set units = ThisWorkbook.Names("Units").RefersToRange Worksheets("Sheet1").Range("Year_Max").Value =...