Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-09-2020, 12:20 AM
djced djced is offline Delete text between 'from' 'to' text strings Windows XP Delete text between 'from' 'to' text strings Office 2007
Novice
Delete text between 'from' 'to' text strings
 
Join Date: Jan 2020
Posts: 5
djced is on a distinguished road
Question Delete text between 'from' 'to' text strings

In various stereotyped documents, I am trying



1. to delete few lines and paragraphs in between text strings "service on the seller" to "service on the Buyer"
I tried this code, but it deletes all the lines after "service on the seller" till end of the document, even after removing or changing "myrange.End"

Code:
Sub SelectRangeStarttext()
    Selection.HomeKey Unit:=wdStory
    
    Dim myrange As Range
    Selection.HomeKey wdStory
    Selection.Find.ClearFormatting
    With Selection.Find
        .Execute FindText:="service on the seller", Forward:=True, Wrap:=wdFindStop 'this will initiate the start word '"The value for the purpose of court fee and jurisdiction"
        Set myrange = Selection.Range
        myrange.End = ActiveDocument.Range.End
        myrange.Start = myrange.Start
        myrange.End = myrange.End + InStr(myrange, "service on the Buyer") ' this will initiate the end word
        myrange.Select
        
        Selection.Delete
    End With
End Sub
2. also i need to delete page containing text strings "removal Slip"

thanking you for your support
Reply With Quote
 

Tags
delete page, delete text between, from to text strings



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extracting Specific Text Strings PWH68 Word VBA 6 10-08-2019 02:07 AM
Locating/deduping similar but not identical text strings strodden Excel 2 06-25-2018 10:37 AM
Delete text between 'from' 'to' text strings Renaming several strings of text by their pattern noname91 Word 10 01-05-2017 05:46 PM
how do I search the content of excel files for text strings soren Excel 2 03-19-2015 09:42 AM
Delete text between 'from' 'to' text strings VBA to copy bookmark-hyperlinks to plain text strings Marrick13 Word 2 04-29-2012 05:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft