title: Copy and paste a cell value on the last row of a column
body: <p>I'm facing a small issue, i need to write a code that copy a cell value and paste in in the last row found of a column (column L in my case), here is what i wrote:</p>
  <pre><code>lastRow = ThisWorkbook.Sheets(&quot;RecordAccordo&quot;).Range(&quot;L&quot; &amp; ThisWorkbook.Sheets(&quot;RecordAccordo&quot;).Rows.Count).End(xlUp).Row
  
          Range(&quot;B36&quot;).Copy
          
          ThisWorkbook.Sheets(&quot;RecordAccordo&quot;).Range(&quot;L2:L&quot; &amp; lastRow).PasteSpecial Paste:=xlPasteValues
  </code></pre>
  <p>My issue is that the value of cell B36 is pasted on all the column L rows while i need it only in the last row found</p>