|
跑跑2014 发表于 2014-6-25 20:45
非常感谢,是我想要的部分效果.还有一点,不好意思,我给解释错误了,就是"审核:加上名字,后面的 "" ... - Sub 加分页符八()
- Dim strSearch As String
- Dim strName As String
- Dim strQianMing As String
- 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)
- strSearch = Sheet110.Range("D1:D" & i).Find(what:="承租单位:", after:=Sheet110.Range("D" & i), SearchDirection:=xlPrevious, lookat:=xlPart).Value
- strSearch = Mid(strSearch, 6, WorksheetFunction.Max(InStrRev(" ", strSearch) - 5, 4))
- strName = Sheet5.Range("AB2:AB" & Sheet5.Cells(Rows.Count, "AB").End(3).Row).Find(what:=strSearch, lookat:=xlWhole).Offset(0, 3).Value
- strQianMing = Sheet110.Range("D" & i)
- strQianMing = WorksheetFunction.Replace(strQianMing, InStr(strQianMing, "审核:") + 6, 4, strName)
- Sheet110.Range("D" & i) = strQianMing
- End If
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|