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


@Palaniyappan

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

1 Like

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

1 Like

great
@Aditya10989

1 Like

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

did we try with CLICK IMAGE activity.
@Aditya10989

No.click image means select OK button…?
Actually I applied if element exist.it exist and go inside but not able to click OK button