Hi Guys,
I have this code right now which filters for a certain date:
How do i tell the macro that if it doesn't find that date, it should have a box pop up saying there were no results?Dim monthlybuys As Worksheet Set monthlybuys = ThisWorkbook.Worksheets("Monthly Buys") ActiveSheet.Range("$A$1:$CN$760").AutoFilter Field:=14, Criteria1:="SA68" ActiveSheet.Range("$A$1:$CN$760").AutoFilter Field:=10, Operator:= _ xlFilterValues, Criteria2:=Array(0, CDate("08/20/2013"))
Cheers!
Bookmarks