Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-04-2021, 05:55 AM
CharlieM CharlieM is offline Duplicating Ranges and changing Font Attributes Windows 10 Duplicating Ranges and changing Font Attributes Office 2016
Novice
Duplicating Ranges and changing Font Attributes
 
Join Date: Aug 2021
Posts: 2
CharlieM is on a distinguished road
Default Duplicating Ranges and changing Font Attributes

I have a Word document which has Hyperlinks which may contain subscripts. I have a special Character Style("MyStyle"), which I sometimes need to convert these Hyperlinks to. But if I select each Hyperlink as a Range and then change the Range.Font to MyStyle, the Range.Text all returns to plain, and the subscripts are lost. I have tried pasting the Range Text after the Range and then using a For Loop to try and duplicate the Font Attributes, also creating a second Range and again using a For Loop, all to no avail.

newRg = .Range.Duplicate
newRg.SetRange(.Range.Start + Len(.Range.Text), .Range.End + Len(.Range.Text))
newRg.Select() ' This attempt to move newRg to after .Range has no effect

newRg.Start = .Range.Start + Len(.Range.Text)
newRg.End = .Range.End + Len(.Range.Text) ' Nor does this ...

The second part of the problem is the Font Change:

newRg.Style = "MyStyle" 'here the subscripts are lost

For i = 1 To .Range.Characters.Count


newRg.Characters(i + Len(.Range.Text)).Font.Subscript = .Range.Characters(i).Font.Subscript
Next ' And this has no effect at all.

I fear I am missing something very fundamental! Could anyone help please? If I could simply get the two (identical) ranges positioned one after the other, then I could use the For Loop as shown. But duplicating the range and then trying to move it does not seem to work.

Last edited by CharlieM; 08-04-2021 at 10:34 PM.
Reply With Quote
 

Tags
copying ranges, range styles/fonts



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to write individual lines of text with changing attributes. sts023 Word VBA 0 05-26-2019 07:43 AM
Duplicating Ranges and changing Font Attributes Take String of numbers, expand ranges, sort, then compress back into ranges AustinBrister Word VBA 19 08-22-2016 05:18 PM
Changing font TonyH Outlook 0 05-22-2014 07:58 AM
Duplicating Ranges and changing Font Attributes Changing font in VBA blaze Word VBA 1 04-15-2012 02:21 AM
changing font size without changing leading carolns Word 1 09-14-2009 12:30 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:57 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