Home Excel Powerpoint Word Outlook Error Codes

VBA Useful Codes

Welcome to the World of VBA
Home > VBAUsefulCodes

Filter Multiple Criteria with VBA


An Autofilter demo with filtering multiple criterias.

Private Sub CommandButton1_Click()
Range("A4").Select
With Selection
.AutoFilter Field:=1, Criteria1:=Array("LG", "SONY", "SAMSUNG"), Operator:=xlFilterValues
End With
End Sub

Subscribe

Enter your e-mail below and get notified on the latest blog posts.




Tags

VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts


Follow Us