Hi Xander1981,
Welcome to ExcelFox !!!
try something like
BTW, add code tags while posting code on the forum. This time I added for you.Code:If Application.WorksheetFunction.CountIf(Range("T:T"), dDate) Then Range("A2").AutoFilter field:=20, Criteria1:=dDate End If![]()




Reply With Quote

Bookmarks