![]() |
#7
|
||||
|
||||
![]()
If you want the whole paragraph then it is opara
Code:
Sub Macro2() Dim oRng As Range Dim oPara As Paragraph Dim sText As String For Each oPara In ActiveDocument.Paragraphs Set oRng = oPara.Range With oRng.Find Do While .Execute(FindText:="010^t") If oRng.start = oPara.Range.start Then sText = oPara.Range 'do something with stext e.g. MsgBox sText End If oRng.Collapse 0 Loop End With Next oPara lbl_Exit: Set oRng = Nothing Set oPara = Nothing Exit Sub End Sub Code:
Sub Macro3() Dim oRng As Range Dim sText As String Set oRng = ActiveDocument.Range With oRng.Find Do While .Execute(FindText:="010^t") If oRng.start = oRng.Paragraphs(1).Range.start Then sText = oRng.Paragraphs(1).Range.Text 'do something with stext e.g. MsgBox sText End If oRng.Collapse 0 Loop End With lbl_Exit: Set oRng = Nothing Exit Sub End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
keywestsue | Excel | 3 | 09-18-2015 07:32 AM |
How to extract only numbers from a STRING? | Learner7 | Excel | 3 | 07-02-2013 06:25 AM |
![]() |
OTPM | Excel | 6 | 05-13-2011 12:52 AM |
Extract numbers from a text string | aleale97 | Excel | 4 | 02-10-2011 10:33 AM |
Extract from String using Wildcard | whousedmy | Word | 0 | 05-21-2009 01:35 AM |