Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-20-2015, 04:22 PM
gmaxey gmaxey is offline Macro that formats (true title) case by Heading style Windows 7 32bit Macro that formats (true title) case by Heading style Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,636
gmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nicegmaxey is just really nice
Default

Marrick,



The method Graham and I used looped through each element of an array and searched for each element of that array in the Heading 1 text. Apparently that process simply takes more time than looping though a simple count and evaluating InStr. It is hardly noticeable with one or two heading but certainly apparent in large documents as Paul demonstrated.

He is usually pretty good at seeing those efficiencies and school all of us here.
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #2  
Old 09-20-2015, 06:29 PM
macropod's Avatar
macropod macropod is offline Macro that formats (true title) case by Heading style Windows 7 64bit Macro that formats (true title) case by Heading style Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,525
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

Quote:
Originally Posted by gmaxey View Post
He is usually pretty good at seeing those efficiencies and school all of us here.
Sometimes ... I'm still learning from you guys too
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
loop style format case



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 05:59 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