title: VBA setting the formula for a cell
body: <p>I'm trying to set the formula for a cell using a (dynamically created) sheet name and a fixed cell address. I'm using the following line but can't seem to get it working:</p>
  
  <pre><code>"=" &amp; strProjectName &amp; "!" &amp; Cells(2, 7).Address
  </code></pre>
  
  <p>Any advice on why this isn't working or a prod in the right direction would be greatly appreciated.</p>