Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 01-25-2020, 11:16 AM
BobBridges's Avatar
BobBridges BobBridges is offline Macro Help: Keep formatting Windows 7 64bit Macro Help: Keep formatting Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

No, I was wrong; it must have been some other property or method that wasn't there, because I'm now able to say "Set och = ActiveCell.Characters(Start,Length)". And when I examine och in the Watches window, I see that the various Font properties are as I set them originally, with Superscript and Subscript etc.

So it seems to me that you can, if you're willing to go to the necessary work, identify which characters in the cell's Text property are to have special handling, and to duplicate that handling in Word. But I'm guessing there's no way to do it in one easy step; you'd have to examine the text character by character as part of copying it over.

Unless, of course, you already know which characters should be suped and subed and just hard-code that.

I haven't forgotten that you claim to be "no expert"; feel free to ask about the parts of this that you don't understand.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Help: Keep formatting Macro to convert formatting? CTHockeyBA Word VBA 1 09-25-2018 06:13 PM
Conditional Formatting in a Macro jennyyoung Excel Programming 15 05-17-2018 09:39 AM
Conditional Formatting Macro grexcelman Excel Programming 1 01-10-2015 04:45 PM
Macro Help: Keep formatting Macro for text formatting georgekung84 Word VBA 15 08-08-2012 06:28 PM
Formatting macro Ulodesk Word Tables 9 04-10-2012 06:37 PM

Other Forums: Access Forums

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