本帖最后由 moonlit123 于 2019-10-2 17:26 编辑
- Sub 移动()
- Dim arr(), brr(), r, i, m
- arr = Sheet1.[a1].CurrentRegion.Value
- r = UBound(arr, 1) * UBound(arr, 2)
- ReDim brr(1 To r, 1 To 2)
- m = 0
- For j = 1 To UBound(arr, 2) Step 2
- For i = 1 To UBound(arr, 1)
- m = m + 1
- brr(m, 1) = arr(i, j)
- brr(m, 2) = arr(i, j + 1)
- Next i
- Next j
- Sheet1.[a1].CurrentRegion.ClearFormats
- Sheet1.[a1].CurrentRegion.ClearContents
- Sheet1.[a1].Resize(UBound(brr, 1), UBound(brr, 2)).Value = brr
- Sheet1.[a1].Resize(UBound(brr, 1), UBound(brr, 2)).Borders.LineStyle = 1
- Erase arr
- Erase brr
- End Sub
复制代码 |