- Sub 查找()
- Dim brr(1 To 100)
- arr = [q9:v16]
- For i = 1 To UBound(arr)
- For j = 2 To UBound(arr, 2)
- If arr(i, j) > 0 Then brr(arr(i, j)) = arr(i, 1)
- Next
- Next
- arr = [c10:h12]
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If arr(i, j) > 0 Then arr(i, j) = brr(arr(i, j))
- Next
- Next
- [J15].Resize(UBound(arr), UBound(arr, 2)) = arr
- End Sub
复制代码 |