title: Getting a value from a named range in VBA
body: <p>I want to retrieve a value from named range. Imagine a named range that has X columns and Y rows. I want to return a value, e.g., from column 2, row 3. The issue I experience is that if I write the code and run it, Excel throws an error. If I write the code into the watch window, it returns fine. See below</p>
  
  <pre><code>...
  Dim NamedRange As Variant: NamedRange = Range(NamedRangeName)
  ...
  Dim ReturnValue As Object
  Set ReturnValue = NamedRange(RowIndex, ColumnToRetrieveIndex) 'Throws Run-time error 424. Object required
  </code></pre>
  
  <p>If I write
  NamedRange(RowIndex, ColumnToRetrieveIndex)
  into the watch window, I can see the correct value of the cell.</p>
  
  <p>I don't know VB much so I guess it's just some kind of syntax error how I want to pass it into the ReturnValue but I just can't figure it out.</p>