|
发表于 2014-11-3 10:06
|
显示全部楼层
本楼为最佳答案
qinhuan66 发表于 2014-11-3 09:48
你好版主可以了。但发现一个问题如果第一次生成35条数据,第二次只生成10条数据,第一次的11至35条数据还 ... - Sub 生成打印数据()
- Dim i%, j%, k%
- Dim sht As Worksheet
- Set sht = Worksheets("住院报销登记")
- For k = 5 To 285 Step 40
- Debug.Print Cells(k, 2).Resize(35, 7).Address
- Cells(k, 2).Resize(35, 7).ClearContents
- Next
- k = 4
- With sht
- For i = 5 To .[A4].End(xlDown).Row
- If n = 35 Then
- n = 0: x = x + 1: k = 40 * x + 4
- Cells(k + 1, 2).Resize(35, 7).ClearContents
- End If
- If [H3] >= .Cells(i, 8) And .Cells(i, 8) >= [G3] Then
- If .Cells(i, 3) = [j3] Or (Len([j3]) = 0) Then
- If .Cells(i, 4) = [k3] Or (Len([k3]) = 0) Then
- If .Cells(i, 5) = [l3] Or (Len([l3]) = 0) Then
- n = n + 1: k = k + 1
- For j = 2 To 8
- Cells(k, j) = sht.Cells(i, j)
- Next
- End If
- End If
- End If
- End If
- Next
- End With
- End Sub
复制代码 |
评分
-
查看全部评分
|