Macro to Filter "0" and delete entire row

[deepakga123]

Hi Team,

Appreciate your help here
I want to filter out "0" from column F and delete entire row through macro.
Need dynamic code for my huge data

 

[Fluff]

How about

Sub deepakga()
   With ActiveSheet
      .Range("A1:F1").AutoFilter 6, "0"
      .AutoFilter.Range.Offset(1).EntireRow.Delete
      .AutoFilterMode = False
   End With
End Sub

 

[deepakga123]

Thanks Fluff,
Code is doing exactly what I wanted.

 

[Fluff]

Glad to help & thanks for the feedback.