title: Why the VBA UDF "Range.Formula =" don't work?
body: <p>I want to copy the formula from one cell/cells to another cell/cells by <code>Range.Formula = </code>.
  But it not work as expected.</p>
  <p>If I run the VBA step by step, the function will ended at <code>Range.Formula = </code> without error.</p>
  <pre><code>Function test1(sOURCE As Range, tARGET As Range)
      tARGET.Formula = sOURCE.Formula
      test1 = tARGET.Formula
  End Function
  </code></pre>
  <p><a href="https://i.stack.imgur.com/lDh3A.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lDh3A.png" alt="Excel cells value" /></a></p>