title: Excel VBA - Set variable to value of formula
body: <p>Is there anyway to set a variable in VBA to the result/value of a formular.
  I need it to calculate the result in VBA and not in a cell.</p>
  
  <pre><code>Variable1 = "=SUBTOTAL(3,INDIRECT('New Sheet 1'!A3:A4500))"
  Variable2 = "=SUMPRODUCT(--ISERR('New Sheet 1'!J3:J4000))"
  Variable3 = "=COUNTBLANK('New Sheet 1'!P2:P4000)"
  </code></pre>
  
  <p>Already here I see some issues using the '-marks.</p>
  
  <p>Thanks in advance!</p>