title: Copy and paste using last row, Error 91
body: <p>I am trying to copy and paste a range of values based on the last row in the range, meaning that the number of rows will vary but the number of columns will all ways stay the same. </p>
  
  <p>The code I have written to do this continues to return the error : </p>
  
  <blockquote>
    <p>Object Variable or With Block Variable not set</p>
  </blockquote>
  
  <p>What does this error mean and how do I fix it?</p>
  
  <pre><code>Sub update()
  
  Dim LR As Range
  Dim Revise As Range
  
  LR = Cells(Rows.Count, "M").End(xlUp).Row
  
  Set Revise = Range("M1:M" &amp; LR)
  
  Revise.Copy
  
  Sheets(Weekly).Select
  Cells(1,1).PasteSpecial xlPasteAll
  
  
  End Sub
  </code></pre>
  
  <hr>