I have tried this code in other sheet it is , but it is not working properly in kitexl sheet, not executing last three line
Highlighted lines in Bold is skipping and going some other function Please Help Private Sub AutoFilter() On Error Resume Next Sheet4.Activate Range("A3:F53").Select Selection.AutoFilter Field:=6, Criteria1:="<-3%", Operator:=xlOr, Criteria2:=">3%" Range("A3:B53").Select_ Range("A3:B53").Copy_ Sheet3.Activate Range("K5").PasteSpecial (xlPasteValues) End Sub
Just remove the error handler 'On Error Resume Next'
and run the code.
If any error in the code, it will be thrown.
Post the actual error you got here.