|
- Sub AA()
- Dim RG As Range, M%, ARR()
- Dim wb As Workbook
- For Each RG In Range(Cells([a65536].End(3).Row, "D"), Cells(Rows.Count, "e").End(3))
- If Not RG.Comment Is Nothing Then
- M = M + 1
- ReDim Preserve ARR(1 To 3, 1 To M)
- ARR(1, M) = RG.Value
- If RG.Column = 4 Then
- ARR(2, M) = RG.Offset(, 2).Value
- ARR(3, M) = RG.Offset(, 6).Value
- Else
- ARR(2, M) = RG.Offset(, 1).Value
- ARR(3, M) = RG.Offset(, 5).Value
- End If
- End If
- Next RG
- Set wb = Workbooks.Open(ThisWorkbook.Path & "/清砂.xls")
- With wb.Sheets(1)
- .Range("b" & .[b65536].End(3).Row + 1).Resize(UBound(ARR, 2), UBound(ARR)) = Application.WorksheetFunction.Transpose(ARR)
- End With
- wb.Close True
- Set wb = Nothing
- End Sub
复制代码 |
|