|
- Sub CC()
- Dim Arr, Hx As Integer, Brr, X As Integer, Lx As Byte
- Arr = Sheet1.UsedRange
- ReDim Brr(1 To UBound(Arr) * 3, 1 To 3)
- For X = 2 To UBound(Arr)
- For Lx = 3 To UBound(Arr, 2)
- If Arr(X, Lx) <> "" Then
- Hx = Hx + 1
- Brr(Hx, 1) = Arr(X, Lx)
- Brr(Hx, 2) = Arr(X, 1)
- Brr(Hx, 3) = Arr(X, 2)
- End If
- Next
- Next
- Sheet2.Cells.ClearContents
- Sheet2.Range("A1:C1") = Array("地址", "事件名称", "日期")
- Sheet2.Range("A2").Resize(Hx, 3) = Brr
- End Sub
复制代码
|
|