View Single Post
 
Old 08-21-2024, 08:52 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,163
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

A simpler method of dealing with this data is to use split to break the entire document into a string array.
Code:
Sub Macro2()
  Dim arrClauses() As String, i As Integer
  arrClauses = Split(ActiveDocument.Range.Text, "#")
  For i = 1 To UBound(arrClauses) 'intentionally excludes entry before first #
    MsgBox arrClauses(i)
  Next i
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote