VBA Code to AutoFilter by Criteria in Excel

This code applies an AutoFilter to the selected range based on a specific criteria.

VBA Code:

Sub AutoFilterByCriteria()
    Dim criteria As String
    
    criteria = "Criteria"
    Selection.AutoFilter Field:=1, Criteria1:=criteria
End Sub

Check All VBA Codes

Join Our Telegram Group techguruplus telegram group Join Our WhatsApp Group techguruplus whatsapp group

Leave a Comment