|
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim ar, br
- Dim s As String
- Dim i As Integer, j As Integer, k As Integer
- If Target.Address <> "$A$2" Then Exit Sub
- s = Target.Value
- ar = Sheet1.Range("a1").CurrentRegion
- ReDim br(1 To UBound(ar), 1 To UBound(ar, 2))
- k = 1
- For i = 1 To UBound(ar, 2)
- br(k, i) = ar(1, i)
- Next
- For i = 2 To UBound(ar)
- If ar(i, 2) = s Then
- k = k + 1
- For j = 1 To UBound(ar, 2)
- br(k, j) = ar(i, j)
- Next
- End If
- Next
- Range("c:e").Clear
- Range("c1").Resize(k, 3) = br
- Range("c1").Resize(k, 3).Borders.LineStyle = xlContinuous
- End Sub
复制代码
高级筛选求助.rar
(10.46 KB, 下载次数: 13)
|
|