title: Formula and text combined within VBA code
body: <p>I am having an issue with combining a formula with text in the VBA format. Can anyone hel :) The line of my code which errors with a 1004 error is;</p>
  
  <pre><code>Range("D4").Value = "=Control Page'!$M$9&amp;" Cost Challenge FTE Tracker by Month"
  </code></pre>
  
  <p>I would like to pick up the values within Worksheet Controlpage'!$M$9 and combine it with the text Cost Challenge FTE Tracker by Month. </p>
  
  <p>I am sure this should be a simple fix. </p>
  
  <p>Any help would be much appreciated.</p>
  
  <p>Thanks
  Sean </p>