Hi , I have the folowing simple code
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
With Worksheets("PutawayQ")
.Select
.Range("A1").AutoFilter Field:=1, Criteria1:=Target.Value
End With
End Sub
At present when I click any cell in the active sheet it filters by that value.
How can I make it will only work when a cell in Collumn A is sellected ,
I am guessing that it is something to do with the Range("A1").
I have tried various things ("A") , ("A1:A1000) ect but without any luck
Can anybody help
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Cancel = True
With Worksheets("PutawayQ")
.Select
.Range("A1").AutoFilter Field:=1, Criteria1:=Target.Value
End With
End Sub
At present when I click any cell in the active sheet it filters by that value.
How can I make it will only work when a cell in Collumn A is sellected ,
I am guessing that it is something to do with the Range("A1").
I have tried various things ("A") , ("A1:A1000) ect but without any luck
Can anybody help