排版问题

gezizaifei

问题及要求见附件

一把小刀闯天下

'应该差不多，满意来朵小花

Option Explicit

Sub test()
  Dim arr, i, j, k, m, n, t
  arr = Sheets("数据源").[a1].CurrentRegion
  ReDim brr(1 To (UBound(arr, 1) - 1) * (UBound(arr, 2) - 4) / 3, 1 To 8)
  For j = 5 To UBound(arr, 2) Step 3
    n = n + 1
    t = Split(arr(1, n + 4), "A")(1)
    t = Left(t, 4) & "/" & Mid(t, 5, 2) & "/" & Right(t, 2)
    For i = 2 To UBound(arr, 1)
      m = m + 1: brr(m, 1) = t
      For k = 1 To 4: brr(m, k + 1) = arr(i, k): Next
      For k = 6 To 8: brr(m, k) = arr(i, (k - 6) * 5 + 4 + n): Next
  Next i, j
  With Sheets("要求结果").[a2]
    .Resize(Rows.Count - 1, UBound(brr, 2)).ClearContents
    .Resize(UBound(brr, 1), UBound(brr, 2)) = brr
  End With
End Sub

gezizaifei

mikezhan 发表于 2018-8-21 14:55
楼上这个不对。我这个完美无误。

Sub test()

想问下[A2].Resize(UBound(brr), 8) = brr这句是什么意思，我没有搞明白