Thread
: [Solved]
Macro to count and export results
View Single Post
07-23-2014, 12:14 PM
gmaxey
Windows 7 32bit
Office 2010 (Version 14.0)
Expert
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,617
Sub ScratchMacro()
Dim arrContent() As String
Dim strTrigger As String
strTrigger = "zzz"
arrContent() = Split(ActiveDocument.Range.Text, "zzz")
Set oDoc = Documents.Add
oDoc.Range.Text = Ubound(arrContent)
End Sub
__________________
Greg Maxey
Please visit my web site at
http://www.gregmaxey.com/
gmaxey
View Public Profile
Find all posts by gmaxey