Understanding Range Names in Excel
by Lisa Ryan
1. Topics
1.1. Benefiting from Use
1.2. Using Range Names
1.2.1. Navigating with Range Names
1.2.2. Using a Range Name in a Formula
1.2.3. Using Range Names in VBA Code
1.2.4. Setting Print Areas
1.2.5. Marking Data Entry Locations
1.3. Creating Range Names
1.3.1. Using the Name Manager
1.3.2. Using the Name Box
1.3.3. Creating Row/Columns Range Names
1.3.4. Testing the Range Name
1.3.5. Modifying Range Names
1.3.5.1. Adjust Existing Range Names
1.3.5.2. Delete a Range Name