|
- Sub demo()
- Dim ar, br, i, n, x
- If Sheets("x1").AutoFilterMode = False Then MsgBox "没有筛选": Exit Sub
- x = Sheets("x1").AutoFilter.Filters(1).Criteria1
- x = Val(Right(x, Len(x) - 1))
- ar = Sheets("x1").Range("a1:b" & Sheets("x1").Cells(Rows.Count, 1).End(3).Row)
- ReDim br(1 To UBound(ar) + 1, 1 To 2)
- For i = 1 To UBound(ar)
- If ar(i, 1) = x Or ar(i, 1) = "选择" Then
- n = n + 1
- br(n, 1) = ar(i, 2)
- br(n, 2) = ar(i, 1)
- End If
- Next
- Columns("a:b").ClearContents
- Range("a1").Resize(n, 2) = br
- End Sub
复制代码 附件楼下
|
|