|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 等差2的两行数据()
- Dim Arr, Brr, i&, j&, m&, k&
- Dim Dic(), Dic2()
- Arr = [C3:V20]
- ReDim Brr(2 To UBound(Arr), 1 To 40)
- m = UBound(Arr, 2)
- For i = 2 To UBound(Arr)
- ReDim Dic(-1 To 82), Dic2(-1 To 82)
- For j = 1 To m
- Dic(Arr(i - 1, j)) = Arr(i - 1, j)
- Next j
- For j = 1 To m
- If Dic(Arr(i, j) - 2) <> "" Then Dic2(Arr(i, j) + 2) = Arr(i, j) + 2
- If Dic(Arr(i, j) + 2) <> "" Then Dic2(Arr(i, j) - 2) = Arr(i, j) - 2
- Next j
- k = 0
- For j = 1 To 80
- If Dic2(j) <> 0 Then k = k + 1: Brr(i, k) = j
- Next j
- Next i
- [X25].Resize(UBound(Brr) - 1, 40) = Brr
- End Sub
复制代码 |
|