Hi,
I am using this code to auto filter a data in excel but it is taking to much time to calculate please help me make it run faster if possible
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A9:T4000").AdvancedFilter Action:=xlFilterInPlace, CriteriaRange:=Range _
("E2:J3"), Unique:=False
End Sub
Bookmarks