|
发表于 2011-8-13 11:38
|
显示全部楼层
本楼为最佳答案
本帖最后由 fjmxwrs 于 2011-8-13 11:40 编辑
- Sub aa()
- Dim arr, arr1(), i&, j&, y&, r&, x&, arr2, arr3()
- With Sheets("1日")
- r = .Range("B65536").End(xlUp).Row
- arr = .Range("C7:AA" & r).Value
- arr2 = .Range("AU7:AV" & r).Value
- End With
- For x = 1 To UBound(arr)
- If arr(x, 2) <> "" And arr(x, 24) = "" Then
- i = i + 1
- ReDim Preserve arr1(1 To UBound(arr, 2), 1 To i)
- ReDim Preserve arr3(1 To 2, 1 To i)
- For y = 1 To UBound(arr, 2)
- arr1(y, i) = arr(x, y)
- Next y
- For j = 1 To 2
- arr3(j, i) = arr2(x, j)
- Next j
- End If
- Next x
- With Sheets("2日")
- .Range("C7").Resize(UBound(arr1, 2), UBound(arr1)) = Application.Transpose(arr1)
- .Range("AU7").Resize(UBound(arr3, 2), UBound(arr3)) = Application.Transpose(arr3)
- End With
- End Sub
复制代码 运行此宏即得
8月份.rar
(47.12 KB, 下载次数: 20)
|
|