title: Working inside named range, referencing to row and column of named range
body: <p>So i have a question about named range and the way to reference and stay in them. </p>
  
  <p>I am able to extract a specific row from the named range and then loop through all the column. but when i try to get the column number, i do not get it from within the named range but from the whole sheet.</p>
  
  <pre><code>    For Each rng1 In Tray_System.Rows
          If rng1.Cells(1, 1).Value = "Truck Dumper" Then
              Debug.Print rng1.Address
              Set Tray_row = rng1
          End If
      Next
  
      For Each rng2 In tray_row.Columns
      If rng2.Value = "X" Then
          Debug.Print rng2.Column
      End If
      Next
  </code></pre>
  
  <p>I hope i'm being clear about my question, i want to make this short.</p>
  
  <p>Basicaly, what i'm trying to do is: </p>
  
  <ul>
  <li>Look for which row in the named range starts with what i'm looking for (e.g. "Truck Dumper")</li>
  <li>From that row, look in each cell if the value is X</li>
  <li>For each cell with an X retrieve the name of the Column</li>
  </ul>
  
  <p>The problem is the column number i get from rgn2.column isnt relative to the named range.</p>