![]() |
#18
|
||||
|
||||
![]()
Not only have you added new rows, you've deleted one that was there previously. Moving targets are rather hard to code for. Try:
Code:
Sub MailMergeToDoc() Application.ScreenUpdating = False Dim Tbl As Table, r As Long, c As Long ActiveDocument.MailMerge.Execute For Each Tbl In ActiveDocument.Tables With Tbl If InStr(Split(.Cell(1, 1).Range.Text, vbCr)(0), "Total Reward Statement") > 0 Then For r = .Rows.Count To 1 Step -1 If Split(.Cell(r, 1).Range.Text, vbCr)(0) = "Shares Total Reward Statement" Then Exit For Select Case Trim(Split(.Cell(r, 1).Range.Text, vbCr)(0)) Case "PSP Award", "DBP Award", "RSP Award" If Split(.Cell(r, 4).Range.Text, vbCr)(0) = "" Then For c = 4 To 1 Step -1 .Cell(r, c).Delete Next End If End Select Next End If End With Next Application.ScreenUpdating = False End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
how to delete every blank and non-numeric rows without removing the header | enuff | Excel | 3 | 08-24-2017 05:56 AM |
Removing blank pages at the end of a document | Xanzia | Word | 3 | 06-01-2014 11:13 AM |
![]() |
Welshie82 | Mail Merge | 2 | 11-14-2011 01:41 AM |
Urgent help needed with removing blank lines... | iammom2four | Outlook | 0 | 12-15-2010 06:12 AM |
![]() |
sieler | Word | 3 | 04-12-2009 01:38 PM |