|
发表于 2012-8-9 13:35
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim i As Long, j As Long, k As Long
- Dim num1 As Long, num2 As Long, num3 As Long
- Dim arr, brr
- arr = Sheets(1).Range("a1").CurrentRegion
- ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
- num1 = Val(InputBox("请输入指定第一个任意数:"))
- num2 = Val(InputBox("请输入指定行数:"))
- num3 = Val(InputBox("请输入指定第二个任意数:"))
- For j = 1 To UBound(arr, 2)
- If arr(1, j) = num1 And arr(num2, j) = num3 Then
- k = k + 1
- For i = 1 To UBound(arr)
- brr(i, k) = arr(i, j)
- Next
- End If
- Next
- With Sheets(2)
- .Cells.Clear
- If k > 0 Then .Range("a1").Resize(UBound(arr), k) = brr
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|