Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-29-2020, 01:00 PM
John 4 John 4 is offline Modify macro to move only Blue font footnotes into the Text Windows 10 Modify macro to move only Blue font footnotes into the Text Office 2013
Advanced Beginner
Modify macro to move only Blue font footnotes into the Text
 
Join Date: Oct 2019
Posts: 68
John 4 is on a distinguished road
Default Modify macro to move only Blue font footnotes into the Text

Hi,
I received the following macro on these forums for moving the footnotes into the text and it works very well. However I'd like to modify it so that it only moves footnotes that are in a certain font colour (blue for example), and leaves the other footnotes unmoved. Can anyone help?

Thanks for your time.

Sub MoveFootnotesIntoText()
Application.ScreenUpdating = False
Dim RngSrc As Range, RngTgt As Range, f As Long
With Selection
For f = .Footnotes.Count To 1 Step -1
With .Footnotes(f)
Set RngSrc = .Range
Set RngTgt = .Reference
RngSrc.End = RngSrc.End - 1
RngTgt.Collapse wdCollapseStart
RngTgt.FormattedText = RngSrc.FormattedText
.Delete


Next
End With
Set RngSrc = Nothing: Set RngTgt = Nothing
Application.ScreenUpdating = True
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Modify macro to move only Blue font footnotes into the Text Word macro for selecting text and putting it in footnotes mdhg Word VBA 20 03-06-2024 08:07 AM
Modify macro to move only Blue font footnotes into the Text VBA - Word how to globally change the font and font size in footnotes thomasoj Word VBA 3 01-15-2020 06:26 AM
Modify macro to move only Blue font footnotes into the Text Modify macro to only add bullets to highlighted text if it exists. 14spar15 Word VBA 2 10-30-2018 08:27 PM
Modify macro to move only Blue font footnotes into the Text sum numbers whose font is blue OracleDBA Excel 2 06-29-2018 10:53 AM
All my footnotes turned to blue underlined text. bww Word 0 07-11-2013 08:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:14 AM.


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