I've been Frankenstein'ing code together to try to delete rows based on the date in column A. If the date is older than 6 years from today then that row needs to be deleted. This is what I've come up with. It runs, but it deletes the entire spreadsheet, haha.
![]()
Sub WarrantyExpire() Dim Row As Long For Row = Range("A65536").End(xlUp).Row To 2 Step -1 If Range("A65536").Value < DateAdd("y", -6, Date) Then Cells(Row, 1).EntireRow.Delete End If Next Row End Sub
Bookmarks