Thanks for the response guy. I actually was able to figure it out using some stuff I googled.
For anyone interested, I used something like this:
Range C1 on my sheet is a formula using Workday -1 to get prior business day.![]()
Dim dDate As Date, dTime As Date Dim strDate As String Dim lDate As Long, dblTime As Double Dim dDateTime As Double Range("D4").Select Do Until ActiveCell.Value = "" ActiveCell.Offset(1, 0).Select If ActiveCell.Value <= dDateTime Then Selection.EntireRow.Delete End If Loop
Bookmarks