excel-vba Named Ranges Manage Named Range(s) using Name Manager


Example

Formulas tab > Defined Names group > Name Manager button

Named Manager allows you to:

  1. Create or change name
  2. Create or change cell reference
  3. Create or change scope
  4. Delete existing named range

enter image description here


Named Manager provides a useful quick look for broken links.

enter image description here