|
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim arr, k%, d
- Set d = CreateObject("scripting.dictionary")
- Application.EnableEvents = False
- Me.Range("a65536").End(xlUp).Clear
- arr = Me.Range("a2:a" & Range("a65536").End(xlUp).Row)
- For k = 1 To UBound(arr)
- d(arr(k, 1)) = d(arr(k, 1))
- Next k
- Me.Range("a65536").End(xlUp).Offset(4, 0) = "共" & d.Count & "人"
- Application.EnableEvents = True
- End Sub
复制代码 |
|