title: Insert variable value into cell with text VBA
body: <p>I'm trying to insert the number contained by the variable Row4Num -1 into the Active Cell, along with some text, but I can't quite figure out the syntax. Any help would be greatly appreciated-- Thanks!</p>
  
  <pre><code>      Range("I7").Value = "=""Teams:  &amp; "" Row4Num - 1"
  </code></pre>