title: Using Row(Indirect(string)) not working
body: <p>I have been trying to use <code>=row(indirect("0-5000"))</code> to work like I have read on all literature I could find and yet I keep getting the #REF error, which occurs when it processes the indirect(string) part of the formula. Is there a setting somewhere that is making my function to act improperly?
  <a href="https://i.stack.imgur.com/awEP3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/awEP3.png" alt="enter image description here"></a></p>
  
  <p>I am trying to produce an array of numbers inside a formula at time of calcution (so no stored array), based on a range of two numbers from 2 cells like the example 1/4 of the way down on <a href="https://exceljet.net/formula/create-array-of-numbers" rel="nofollow noreferrer">https://exceljet.net/formula/create-array-of-numbers</a></p>