VBA code to clear content of Filteredout rows

[SKV]

Researched a lot on internet but still no help.

Need VBA code to clear content of all rows in a range including the rows which are filtered out.

Please advice.

 

[kevatarvind]

use below code and change highlighted area as per yours

Sub Clear_Filter_Rows()
With ActiveSheet
    .UsedRange.AutoFilter Field:=2, Criteria1:="GRACE GARMENT LIMITED" ' change Field of filtered and Criteria as per yours
    lastRow = .Range("B" & Rows.Count).End(xlUp).Row 'change field column
    .Range(.Range("B2"), .Range("B" & lastRow)). _
    SpecialCells(xlCellTypeVisible).EntireRow.ClearContents
End With
End Sub