title: Auto-deletion of Yesterday's Entries After a Set Time
body: <p>How do I alter the below code to effect deleting all rows occurring &lt; 5pm Yesterday?</p>
  <pre><code>If wsR.Cells(r, &quot;B&quot;) &lt; CDate(&quot;18/06/2020 17:00:00&quot;) Then
      wsR.Rows(r).EntireRow.Delete
  End If
  </code></pre>
  <p>My thinking is to substitute <code>CDATE</code> with something like <code>(Date-1)+62400</code> to add 17 hours onto the beginning of yesterday but I have no idea how to structure the syntax. I have heard of calling in functions which is way above my skill level; and other threads negate addressing specific timestamps.</p>
  <p>Any pointers would be appreciated.</p>