Advertisement
Guest User

Untitled

a guest
Jul 30th, 2015
174
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Sub DeleteLastOccurence()
  2.  
  3.     Const strKeyWord As String = "Delete"
  4.     Dim rngPicture  As Range
  5.     Dim rngJunk As Range
  6.    
  7.     Set objDoc = ActiveDocument
  8.     objDoc.InlineShapes(1).Delete
  9.    
  10.     Do
  11.         On Error Resume Next
  12.         Set rngPicture = objDoc.InlineShapes(objDoc.InlineShapes.Count).Range
  13.         Set rngJunk = objDoc.Range(0, rngPicture.Start)
  14.         rngJunk.Find.Execute FindText:=strKeyWord, Forward:=False
  15.         On Error GoTo 0
  16.        
  17.         If rngJunk.Find.Found = True Then
  18.             objDoc.Range(rngJunk.Start, rngPicture.End).Delete
  19.         Else
  20.             Exit Do
  21.         End If
  22.        
  23.     Loop While True
  24.  
  25. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement