Converting Formula from Formula Bar to VBA
<p>Anyone knows how to convert this piece of formula to VBA code ? Here is the code : <code>=S4&amp;(AA5&amp;AA6&amp;AA7&amp;AA8&amp;AA9&amp;AA10)</code>. If I try to convert it to VBA, which is as follows:</p>

<pre><code>Dim ws as Worksheet
Set ws = ThisWorkbook.Worksheet("Sheet1")
ws.Range("S4") &amp; = ws.Range("AA5") &amp;
</code></pre>

<p>I always encounter an error. Then I've tried this:</p>

<pre><code>ws.Range("S4&amp;") = ws.Range("AA5&amp;")
</code></pre>

<p>Then I don't know what to do next. Any help? Thanks!</p>