Macro throw error if not found record in excel

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 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 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


is that macro working when executed from excel itself
kindly check that once manually pls

1 Like

thanks its work.I applied condition in macro if number of count is greater then 1 then delete will work

1 Like


1 Like

but this not work I used hot key ,click activity,delay but not work

did we try with CLICK IMAGE activity.
@Aditya10989 image means select OK button…?
Actually I applied if element exist and go inside but not able to click OK button