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:
' Macro1 Macro
ActiveSheet.Range("$A$1:$T$298").AutoFilter Field:=8, Criteria1:="EUR"
End Sub Example.xlsm.xlsx