title: VBA separate two double digit values by a slash in a single cell
body: <p>I feel like this should be relatively straight forward, but I cannot seem to find something that works.</p>
  
  <p>I want to be able to separate two values in a VBA macro that are previously defined as values after doing some preliminary calculations. I then want to be able to put both of these values in the same cell, separated by a slash ("/").</p>
  
  <p>Here are two codes I have written by neither seem to get the job done:</p>
  
  <pre><code>Sub Macro3()
  
  TotalK = 10
  BB = 15
  
  ActiveCell.Value = "=TotalK &amp;""/""&amp; BB"
  
  End Sub
  </code></pre>
  
  <p>The other way I have attempted this (which is extremely inefficient):</p>
  
  <pre><code>If TotalK &gt; 9 Then
       wsNew.Range("E45").NumberFormat = "00""/""0": wsNew.Range("E45").Value = TotalK &amp; BB
  ElseIf BB &gt; 9 Then
       wsNew.Range("E45").NumberFormat = "0""/""00": wsNew.Range("E45").Value = TotalK &amp; BB
  ElseIf TotalK &gt; 9 And BB &gt; 9 Then
       wsNew.Range("E45").NumberFormat = "00""/""00": wsNew.Range("E45").Value = TotalK &amp; BB
  Else
       wsNew.Range("E45").NumberFormat = "0""/""0": wsNew.Range("E45").Value = TotalK &amp; BB
  End If
  </code></pre>
  
  <p>The second method words, except for when TotalK and BB both exceed 9. The output is 211/7, for example, when it should be 21/17.</p>