宏重置表谢谢

宏重置表谢谢

https://i.stack.imgur.com/khvqO.jpg

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Dim dccolumn As Integer
Dim dcvalue As String

dccolumn = ActiveCell.Column
dcvalue = ActiveCell.Value

If Application.Intersect(ActiveCell, [headers]) Is Nothing Then

        If ActiveCell.Value <> "" Then

         Me.ListObjects(1).Range.AutoFilter Field:=dccolumn + 2, Criteria1:=dcvalue

        End If

    End If

End Sub

相关内容