|
数组超限,请高手帮助
- Sub mxzh() '明细统计
- Dim mxzh As Worksheet, pzqd As Worksheet
- Set mxzh = Worksheets("明细统计")
- Set pzqd = Worksheets("记工清单")
- Dim r_end%, x%, j%
- Dim i As Integer, r As Integer, arr(), arr1()
- r_end = pzqd.Cells(Rows.Count, 2).End(xlUp).Row
- arr = pzqd.Range("B5:r" & r_end)
- mxzh.Range("a7:s" & Rows.Count).Clear
-
- mxzh.Range("d4").Select
- i = 1
- j = 1
- With mxzh
- For r = 1 To UBound(arr, 1)
- If arr(r, 11) = Range("l4") And arr(r, 12) = Range("m4") Then
- i = i + 1
- ReDim Preserve arr1(1 To 17, 1 To i)
- For l = 1 To 17
- arr1(l, j) = arr(r, l)
- Next l
- j = j + 1
- Else
- If arr(r, 11) = Range("l4") And Range("m4") = 0 Then
- i = i + 1
- ReDim Preserve arr1(1 To 17, 1 To i)
- For l = 1 To 17
- arr1(l, j) = arr(r, l)
- Next l
- j = j + 1
- End If
- End If
- Next r
-
- [b7].Resize(UBound(arr1, 2), 17) = Application.Transpose(arr1)
- End With
- End Sub
复制代码
|
|