本帖最后由 zjdh 于 2014-6-25 09:02 编辑
问题出在你的表中D列有空单元,所以:
Sub 加分页符八()
Application.ScreenUpdating = False
Sheet110.ResetAllPageBreaks
Dim i As Integer
For i = 2 To Range("D65536").End(3).Row
If Sheet110.Cells(i, 4).Value Like ("制表:*") Then Sheet110.HPageBreaks.Add Before:=Sheet110.Cells(i + 1, 1)
Next
Application.ScreenUpdating = True
End Sub