|
发表于 2013-8-21 10:31
|
显示全部楼层
本楼为最佳答案
- Option Explicit
- Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
- Dim arr0, i, j, k, Tempvalue, arr
- arr0 = Sheets("数据源").Range("B2:V407")
- ReDim arr(1 To UBound(arr0), 1 To UBound(arr0, 2))
- For i = 1 To UBound(arr0)
- For j = 3 To UBound(arr0, 2) Step 3
- If Replace(arr0(i, j), " ", "") = Replace(Target.Value, " ", "") Then
- Tempvalue = Tempvalue + 1
- For k = 1 To UBound(arr0, 2)
- arr(Tempvalue, k) = arr0(i, k)
- Next k
- Exit For
- End If
- Next j
- Next i
- Sheets("结果表").Range("B2:V407") = arr
- Range("A1").Select
- End Sub
复制代码 |
|