Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 09-04-2017, 01:13 PM
peter961 peter961 is offline Modify recorded macro to run until end of document Windows 10 Modify recorded macro to run until end of document Office 2016
Novice
Modify recorded macro to run until end of document
 
Join Date: Jan 2012
Posts: 5
peter961 is on a distinguished road
Default Modify recorded macro to run until end of document

Editing a Word document that contains multiple footnotes that are not numbered seriatim and I want to change them so they are. Here is a macro I have recorded that enables me to replace the existing footnotes one at a time. How do I modify this to replace all the footnotes in the existing document?

Selection.Find.ClearFormatting
With Selection.Find.Font
.Superscript = True
.Subscript = False
End With
With Selection.Find
.Text = ""
.Replacement.Text = "~"
.Forward = True
.Wrap = wdFindAsk
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
With Selection
With .FootnoteOptions
.Location = wdBottomOfPage
.NumberingRule = wdRestartContinuous
.StartingNumber = 1
.NumberStyle = wdNoteNumberStyleArabic


.LayoutColumns = 0
End With
.Footnotes.Add Range:=Selection.Range, Reference:=""
End With
End Sub
  #2  
Old 09-04-2017, 02:50 PM
macropod's Avatar
macropod macropod is offline Modify recorded macro to run until end of document Windows 7 64bit Modify recorded macro to run until end of document Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

Please don't post the same question in multiple threads.

Thread closed. You may continue the discussion in your other thread.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread



Similar Threads
Thread Thread Starter Forum Replies Last Post
Embedded Video Not Playing in Recorded Presentation bhadden1 PowerPoint 0 08-16-2017 03:07 PM
Add previously recorded sound and synchronize with slide annimations daniellouw PowerPoint 1 03-03-2017 11:14 AM
Modify recorded macro to run until end of document how modify a macro code tarikov2006 Excel Programming 1 11-18-2016 04:10 AM
Modify recorded macro to run until end of document how can I modify this macro to work on another column besides "A" zhead Excel Programming 5 10-06-2015 05:04 PM
Can I record more to add on to a recorded Macro? Clueless in Seattle Word VBA 3 05-25-2015 01:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft