Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2015, 08:32 AM
Marrick13 Marrick13 is offline Macro that formats (true title) case by Heading style Windows XP Macro that formats (true title) case by Heading style Office 2010 32bit
Competent Performer
Macro that formats (true title) case by Heading style
 
Join Date: Jun 2006
Posts: 102
Marrick13 will become famous soon enough
Default

Greg,

Sorry for "crediting" you with Graham's code; I must have gotten my "GM's" mixed up (didn't check my sources first!). But competition is good, despite what John D. Rockefeller claimed.

Macropod, thank you. You are correct - your code runs MUCH faster than Greg's. I timed them on a 50-page document with 60 headings, and yours took 237 seconds with screen updating off, and 298 seconds with it on; Paul's ran in 1.5 seconds with updating on and 1.3 seconds with it off. Since they both produce the same results, I'd call that a "no contest".



I've added some counters and attached Paul's version for the record. Thanks, guys, for all your help!
Attached Files
File Type: txt Apply_True_Title_Case_by_Style.txt (2.5 KB, 12 views)
Reply With Quote
Reply

Tags
loop style format case

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro that formats (true title) case by Heading style Tab character causes style change to Heading 4 after macro Jennifer Murphy Word VBA 2 12-14-2015 02:31 AM
Macro to create a title in the Header when a certain text style is used (such as Heading 1) Lonesy Word VBA 1 06-03-2015 03:57 AM
Macro that formats (true title) case by Heading style Customising a style that uses Title Case formatting Madanjeet Word 6 05-18-2015 10:11 AM
Macro that formats (true title) case by Heading style True Title Case for First Row of All Tables Marrick13 Word VBA 14 12-11-2013 09:12 PM
Macro that formats (true title) case by Heading style Macro to replace one specific heading style with another ubns Word VBA 44 09-04-2012 08:17 PM

Other Forums: Access Forums

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