title: Excel Evaluate formula error
body: <p>My VBA code is </p>
  
  <pre><code>Function yEval(entry As String)
  yEval = Evaluate(entry)
  Application.Volatile
  End Function
  </code></pre>
  
  <p>in Sheet1 in cell f4 i have formula <code>=yEval(Sheet2!E19)</code>
  cell d4 on sheet1 contains number 12
  Sheet2!I19 contains string $Q</p>
  
  <blockquote>
    <p>if Sheet2!e19 has string INDIRECT("pries!"&amp;Sheet2!I19&amp;12) or
    INDIRECT("pries!"&amp;Sheet2!I19&amp;Sheet1!d4) or
    INDIRECT("pries!"&amp;Sheet2!I19&amp;"Sheet1!D"&amp;row()+12) the formula return
    result from sheet pries!$Q12</p>
    
    <p>if Sheet2!e19 has string
    INDIRECT("pries!"&amp;Sheet2!I19&amp;address(row(),4)) or
    INDIRECT("pries!"&amp;Sheet2!I19&amp;"Sheet1!D"&amp;row()) the formula return
    result 0 it seems like ignoring the row() function</p>
  </blockquote>
  
  <p>How to make work this formula to change d4 part depending on row number, if row is 5 then d5</p>
  
  <pre><code>INDIRECT("pries!"&amp;Sheet2!I19&amp;Sheet1!d4)
  </code></pre>