|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
Option Explicit
Sub test()
Dim arr, i, p, n
arr = Range("a2:c" & Cells(Rows.Count, "b").End(xlUp).Row + 1)
arr(UBound(arr, 1), 1) = "?"
ReDim brr(1 To UBound(arr, 1), 1 To 30) As String '每户最多支持15人
p = 1
For i = 1 To UBound(arr, 1) - 1
n = n + 2
brr(p, n - 1) = arr(i, 2): brr(p, n) = arr(i, 3)
If Len(arr(i + 1, 1)) Then p = i + 1: n = 0
Next
With [e2]
.Resize(Rows.Count - 1, UBound(brr, 2)).ClearContents
.Resize(UBound(brr, 1), UBound(brr, 2)) = brr
End With
End Sub |
|