Hi Willih, you might try:
![]()
Sub WILLIH() Dim i As Long, LR As Long LR = Range("F" & Rows.Count).End(xlUp).Row For i = LR To 1 Step -1 If Cells(i, "F").Value = Date Then Cells(i, "F").EntireRow.Delete Next i End Sub
Hi Willih, you might try:
![]()
Sub WILLIH() Dim i As Long, LR As Long LR = Range("F" & Rows.Count).End(xlUp).Row For i = LR To 1 Step -1 If Cells(i, "F").Value = Date Then Cells(i, "F").EntireRow.Delete Next i End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks