title: Fix macro code to display a different range
body: <p>I am sure this is a rather simple question for majority of you but I have this code</p>
  
  <pre><code>With ActiveSheet
      .Cells(Rows.Count, "B").End(xlUp).Offset(1, 0) = .Range("L1").Value2
  </code></pre>
  
  <p>This allows me to take the contents of L1 and paste it as a static value in the next available cell in column B. I now want to use this code for a different "range." That range being the combination of the text of two cells into the new one. I use the following code to do just that</p>
  
  <pre><code>With ActiveCell
      .Formula = "=CONCATENATE(L1,N1)"
      .Cells = .Value
      .WrapText = False
  </code></pre>
  
  <p>Except that it will always post the new value into the active cell and it will not register that the value should be pasted in the next available cell Column A. I have tried replacing the first two lines of the code with the following...</p>
  
  <pre><code>With ActiveSheet
      .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0) = .Range("L1&amp;N1").Value2
  </code></pre>
  
  <p>and</p>
  
  <pre><code>With ActiveSheet
      .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0) = .Range("=CONCATENATE(L1,N1)").Value2
  </code></pre>
  
  <p>and</p>
  
  <pre><code>With ActiveSheet
      .Cells(Rows.Count, "A").End(xlUp).Offset(1, 0) = .Formula = "=CONCATENATE(L1,N1)".Value2
  </code></pre>
  
  <p>I'm not too sure what to try next</p>