Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2014, 08:37 PM
macropod's Avatar
macropod macropod is offline Insertbefore an array? help :( Windows 7 32bit Insertbefore an array? help :( Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could use something along the lines of:
Code:
Sub InsertTriangleBefore()
    Dim RngDoc As Range, RngFnd As Range, i As Long, TargetList
    TargetList = Array( ... )     ' put list of terms to find here
    For i = 0 To UBound(TargetList)
        Set RngDoc = ActiveDocument.Range
        With RngDoc
            With .Find
                .Text = TargetList(i)
                .Format = True
                .MatchCase = True
                .MatchWholeWord = False
                .MatchWildcards = False
                .MatchSoundsLike = False
                .MatchAllWordForms = False
                .Execute
            End With
            Do While .Find.Found = True
                Set RngFnd = .Duplicate
                With RngFnd
                    .Collapse wdCollapseStart
                    .Text = ChrW(9660)
                    With .Font
                      .Size = 8
                      .Color = 49407
                      .Superscript = True
                      .Subscript = False
                    End With
                End With
                .Collapse wdCollapseEnd
                .Find.Execute
            Loop
        End With
    Next
End Sub
I'd also suggest using rather more frequent line breaks in your array definition...



PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab at the bottom of this screen
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 08-13-2014, 09:52 PM
n00bie-n00b n00bie-n00b is offline Insertbefore an array? help :( Windows 7 32bit Insertbefore an array? help :( Office 2007
Novice
Insertbefore an array? help :(
 
Join Date: Aug 2014
Posts: 17
n00bie-n00b is on a distinguished road
Default

Wow, thank you Paul! works perfectly.

Is there a similar piece of code i can use for a new array, but to add a character boarder instead of highlight?

If tried recording a macro but cant get it to work.

Thanks again.
Reply With Quote
Reply

Tags
complex, connected, insert, macro, n00b

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding information from a array into a table jcorti Word VBA 4 01-10-2014 10:58 PM
Insertbefore an array? help :( Convert String Array to Integer Array from a User Input? tinfanide Excel Programming 4 12-26-2012 08:56 PM
Insertbefore an array? help :( Complex array formula andrei Excel 9 02-03-2012 03:40 AM
How to capture start and ending Ref. Nos. in an array KIM SOLIS Excel 5 09-07-2011 07:43 AM
Look up an array based on user input johnsmb Excel 2 01-07-2011 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:14 PM.


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