|
大神帮我批改下
- Sub bjg()
- Dim arr, xr(0 To 59), i&, j%, k&, brr()
- arr = Sheets("sheet1").[a1].CurrentRegion
- ReDim brr(1 To UBound(arr) * 7, 1 To 3)
- For i = 2 To UBound(arr)
- For j = 2 To UBound(arr)
- On Error Resume Next
- xr(arr(i, j)) = 1
- If Err.Number = 9 Then GoTo 100
- k = k + 1
- brr(k, 1) = arr(i, 1): brr(k, 2) = arr(1, j): brr(k, 3) = arr(i, j)
- 100
- Next
- Next
- On Error GoTo 0
- Sheets("sheet1").[j2].Resize(k, 3).Clear
- Sheets("sheet1").[j2].Resize(k, 3) = brr
- End Sub
复制代码
|
|