Hi all, could you please help me. i'm trying to auto filter based on active cell, however, when i click onto empty cell, it will show an error. how do i fix this. my code curretnly as below and work well except for empty cell. i want to keep under worksheet so it can auto run
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Selection.AutoFilter Field:=ActiveCell.Column, Criteria1:=ActiveCell.Value
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Selection.AutoFilter Field:=ActiveCell.Column, Criteria1:=ActiveCell.Value
End Sub