Searching for the lone string on a line that starts with a particular character

vivka · #1 03-27-2024, 10:58 AM

Hi! It's not difficult:

Code:

Sub Test()
Dim oRng As range
    Set oRng = selection.range
    With oRng.Find
        .ClearFormatting
        .Replacement.ClearFormatting
        .text = "Y[! ]@" & Chr(13)
        .Format = False
        .Forward = True
        .MatchWildcards = True
        .Wrap = wdFindStop
        .MatchAllWordForms = False
        .MatchSoundsLike = False
        If .Execute Then oRng.Select
    End With
 Set oRng = Nothing
End Sub

Modify the code to meet your needs.

IndianaITGuy · #2 03-27-2024, 11:55 AM

Quote:

Originally Posted by vivka

Hi! It's not difficult:

Code:

Sub Test()
Dim oRng As range
    Set oRng = selection.range
    With oRng.Find
        .ClearFormatting
        .Replacement.ClearFormatting
        .text = "Y[! ]@" & Chr(13)
        .Format = False
        .Forward = True
        .MatchWildcards = True
        .Wrap = wdFindStop
        .MatchAllWordForms = False
        .MatchSoundsLike = False
        If .Execute Then oRng.Select
    End With
 Set oRng = Nothing
End Sub

Modify the code to meet your needs.

You have me at a disadvantage with the value of .Text. I've looked but nothing good really jumped out at me with regard to special characters. Microsoft Help was not much. What is a good reference for all such special codes when searching for text? I've seen combinations of [], (), /, \, *, whatever. I just want to be able to recognize when there is one, specific word/string alone on a line that starts with a letter of my choosing. In my case it will be an X or Y. No whitespaces in this string.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Word macro for deleting a line that starts with a specific character + deleting the line before	eduardb	Word	1	08-10-2022 03:17 AM
How to move a line to another line that starts with a chain selected in the 1st one?	gloub	Word VBA	24	03-19-2019 03:12 PM
Searching for string on a formula	AMD2800	Excel	1	12-17-2014 10:41 AM
Replace paragraph-marks (line-breaks) in tables with a character-string	Aztec	Word VBA	2	04-02-2013 10:52 PM
Finding or searching ^ character in word document	shahin3121	Word	2	03-05-2012 06:16 PM