Locate the Defined Names section, and click Define Names This will open the Name Manger Click on New Type the NameRange ( D1E10) '// specify defined name myRangeName = namedRangeWSscope '// create named range with worksheet scope Defined name and cell range are as specified myWorksheet NamesOne solution is to define a named range using a structured reference, then use the named range for data validation To keep things straight, I'll first rename the table to start with a t for table This will let me see at a glance which range is the table Next, I'll create a named range called Stages using the name manager
Creating And Using Named Ranges Microsoft Excel 365