![]() |
|
#14
|
|||
|
|||
|
It is even simpler:
Code:
Sub Repl_Stri_W_Sequential_Nums()
'In slection, replace all instances of the inputboxed string
'with captions.
Dim myRng As range
Dim stri As String
Application.ScreenUpdating = False
Set myRng = selection.range
stri = InputBox("Enter the string to find")
With myRng.Find
.ClearFormatting
.Replacement.ClearFormatting
.text = "Figure " & stri
.Forward = True
.Wrap = wdFindStop
Do
If .Execute And myRng.InRange(selection.range) Then
myRng.Delete
myRng.InsertCaption label:="Figure", _
TitleAutoText:="", _
Title:="", _
Position:=wdCaptionPositionBelow, _
ExcludeLabel:=0
Else: Exit Do
End If
myRng.Collapse wdCollapseEnd
Loop
End With
Application.ScreenUpdating = True
Set myRng = Nothing
End Sub
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
VBA to insert captions without appending to existing captions
|
Marrick13 | Word VBA | 17 | 03-21-2023 07:51 PM |
Insert Captions and Word Wrap
|
TEAllred | Word | 1 | 11-22-2015 03:21 PM |
Captions: Changing captions in Appendix update all captions
|
carnestw | Word | 3 | 10-27-2015 12:34 PM |
Captions automatically updating all previous entries
|
jhats | Word | 1 | 07-29-2014 11:53 PM |
Captions mixing letters and numbers
|
trew | Word | 7 | 11-21-2012 12:54 AM |