title: Reference Named Ranges in VBA
body: <p>In my Excel workbook, I've made a single cell a named range.  Instead of using vba to do this, I just went to <code>Formulas &gt; Name_Manager &gt; New</code> in Excel.  I now want to refer to this named range in a macro that I'm writing.  The macro will copy the color of a cell if that cell's background color matches that of my named range.</p>
  
  <p>My macro currently works well when I refer to the cell's location as Range("S2") in the following code:</p>
  
  <pre><code>Trans_ECO_Row.Cells(, 13).Value = Trans_Queue_Row.Cells(, 14).Value
      If Trans_Queue_Row.Cells(, 14).Interior.Color = QueueSheet.Range("S2").Interior.Color Then
          Trans_ECO_Row.Cells(, 13).Interior.Color = Trans_Queue_Row.Cells(, 14).Interior.Color
      End If
  </code></pre>
  
  <p>However, I've named cell S2 <code>MGRColor</code> by going to <code>Formulas &gt; Name_Manager &gt; New</code> in Excel.  How can I replace S2 with <code>MGRColor</code> in my above code?</p>