Hi Everyone,
I was trying to remove Dates on my Column that are younger than 180 days. So basically, I can only get the dates that are older than 180 days.
A Forum member helped me with a Macro (see below) and It is working quite well. Except that when I Click the button, for some reasons the button disappears/minimizes.
I've already changed the Button Properties to "Do Not Move or Size with Cells" yet it still disappears after I run the Macro/Click the button.
Could you help? Thank you in advance.
Sub Inactive_180Days()
Application.ScreenUpdating = 0
With ActiveSheet.UsedRange
.AutoFilter 6, ">=" & CLng(DateAdd("d", -181, Date))
.Offset(1).EntireRow.Delete
.AutoFilter
End With
Application.ScreenUpdating = 1
End Sub
Bookmarks