|
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim m, ar, br(), i, n, j
- If Target.Address = "$F$2" Then
- m = Target.Value
- ar = Sheet2.Range("i1:n" & Sheet2.Cells(Rows.Count, "i").End(3).Row)
- ReDim br(1 To UBound(ar), 1 To UBound(ar, 2))
- For i = 1 To UBound(ar)
- If ar(i, 1) <> m Then
- n = n + 1
- For j = 1 To UBound(ar, 2)
- br(n, j) = ar(i, j)
- Next
- End If
- Next
- Sheet2.Range("i1").Resize(UBound(ar), UBound(ar, 2)).ClearContents
- Sheet2.Range("i1").Resize(n, UBound(ar, 2)) = br
- End If
- End Sub
复制代码 附件楼下
|
|