Many thanks. I have now resolved this issue :
Code:ActiveWorkbook.Sheets("PRG CFS Receipts").Select ActiveSheet.Range("a1").AutoFilter 10, Criteria1:="<" & GetDateRangeFrom, Operator:=xlOr, _ Criteria2:=">" & GetDateRangeTo On Error Resume Next ActiveSheet.Range("A2:A1000").SpecialCells(12).EntireRow.Delete Range("A1").Select Selection.AutoFilter




Reply With Quote

Bookmarks