How to reference a 'named range' from Excel using VBA?

I am using the following code to insert a new row:
==============================
Range("B9", "J9").Select
ActiveCell.Offset(0, 0).Select
Selection.EntireRow.Insert
Selection.EntireRow.Interior.ColorInde... = xlNone
Selection.EntireRow.Font.Bold = False
Selection.EntireRow.Font.ColorIndex = 32
Selection.EntireRow.Borders(xlEdgeBottom... = 0
==============================

I want to call a 'named range' that I've established in Excel instead of
hardcoding the cell values like I am doing above: Range("B9", "J9").Select.

I am saying 'named range', but I think it is actually called 'Name Box' in Excel. (It's in the upper left hand corder beneath the file and edit menu.

How do I reference this in code? For example, I have a named range called "Objective 2".

How do I reference 'Objective 2' instead of hardcoding cell A and cell B like I am already doing?

I tried doing this but it doesn't work:
Range("Objective2").Select
ActiveCell.Offset(0, 0).Select
etc..

Thanks!

DK
Start Free Trial