I'm not sure, if i am starting this thread in under right sub-categories of General question, when it relates to specific VBA related issue.

I have many macros running across 1000 plus lines, (So, not putting the entire code) but common line code are auto filtering rows based on certain condition and deletion thereof.

Of late, I'm facing an issue where, if the code in its originality is run, i get the result - Auto filter row, based on some condition but later it does not delete the visible filtered rows, though there is no change in code, but am just copying pasting same criteria. Code is

I want to retain the first row in sheet, which acts as header

Application.DisplayAlerts = False
    

    Worksheets("5KC").Range("A1").AutoFilter Field:=17, Criteria1:=">15000"
    ActiveSheet.UsedRange.Offset(1, 0).Resize(ActiveSheet.UsedRange.Rows.Count - 1).Rows.Delete
     
     Selection.AutoFilter
     Selection.AutoFilter
Original code in another macro which does the job is - 

Application.DisplayAlerts = False

    Worksheets("2CMon").Range("A1").AutoFilter Field:=17, Criteria1:=">15000"
    ActiveSheet.UsedRange.Offset(1, 0).Resize(ActiveSheet.UsedRange.Rows.Count - 1).Rows.Delete
     
     Selection.AutoFilter
     Selection.AutoFilter
Can someone tell me what logical error is preventing this? I'm using Excel version 97-2003, and currently have Installed Office 2013.