macro throw error if not found record in excel as mention in the attachment.My requirement if no record found then it not throw any error.
Actually what happened I have excel sheet which contain almost 15000 records.now I want to delete all record exist between this range
ActiveSheet.ListObjects(“Claims”).Range.AutoFilter Field:=33, Criteria1:= _
“>=-.09”, Operator:=xlAnd, Criteria2:=“<=.01”
ActiveSheet.Range(“A2”, ActiveCell.SpecialCells(xlLastCell)).Select
after remove filter I need to perform multiple task in website.Now in any case application breaks then I restart the bot application and macro again execute.now in this case after filter no record exist because all records are already filter and deleted.then it try to delete empty file then throw an error