How to delete rows after an End (xl Down) without deleting header row?
Hi Guys, I have recorded an Excel macro which puts a Filter in Column 8 for the word "EUR" , then an End (xl down) and then deletes the rows, but I do not want to delete the header row so how do I adapt the code to do this? here's the code:
Sub Macro1()
'
' Macro1 Macro
'
'
Rows("1:1").Select
Selection.AutoFilter
ActiveSheet.Range("$A$1:$T$298").AutoFilter Field:=8, Criteria1:="EUR"
Range("A3").Select
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select
Selection.EntireRow.Delete
Rows("1:1").Select
Selection.AutoFilter
End Sub Example.xlsm.xlsx