title: How to code Excel VBA equivalent of INDIRECT function?
body: <p>I have many uses of the INDIRECT function in my workbook, and it is causing performance issues. I need to replace them with something that will give me the same results. All the INDIRECTS recalculate anytime anything is changed, causing the workbook to lag.</p>
  
  <p>I was wondering if there is a way to code INDIRECT in VBA without actually using the INDIRECT function, and take away the volatility of the function in the code.</p>
  
  <pre><code> =INDIRECT("'" &amp; $AC$9 &amp; "'!" &amp; AC26)
  </code></pre>
  
  <p>This is an example. I need to remove INDIRECT but get the same results for this cell. Is there a way to accomplish this in VBA?</p>