Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2013, 04:26 PM
Marrick13 Marrick13 is offline True Title Case for First Row of All Tables Windows XP True Title Case for First Row of All Tables Office 2010 32bit
Competent Performer
True Title Case for First Row of All Tables
 
Join Date: Jun 2006
Posts: 103
Marrick13 will become famous soon enough
Default True Title Case for First Row of All Tables

Paul,



It works GREAT now - thanks so much. It handles blank first rows and runs much faster than my jalopy of a code. I can also run it repeatedly on the same file - before, the other code seemed to have a problem with a lot of tables, so I was copying blocks of text to the template file, running the macro, then copying the formatted tables back to the main document.

I don't understand all of it, but it does just what I wanted. Thank you again.
Reply With Quote
  #2  
Old 12-10-2013, 12:01 PM
Marrick13 Marrick13 is offline True Title Case for First Row of All Tables Windows XP True Title Case for First Row of All Tables Office 2010 32bit
Competent Performer
True Title Case for First Row of All Tables
 
Join Date: Jun 2006
Posts: 103
Marrick13 will become famous soon enough
Default True Title Case for First Row of All Tables

I'm afraid I signed off on this too soon.

When I run the original True Title macro, which requires selecting the text to be formatted, it sets the case properly. As you can see in the attached ("True Title All Tables Test"), which includes the True Title code as well as the original code that applies it to all tables using the selection method, and your (Paul's) rewrite, the text in the first row of the first table is "Two Men on a Street Corner". This is the correct case, and is the result when I run the True Title macro as well as my original ("FormatAllTablesOrig").

Running our macro ("FormatAllTablesNew") produces "Two Men On a Street Corner" - the "On" is in proper case and should be lower case. The same sort of thing happens with the other four tables.

I chose the selection method only because it worked with the True Title code; your revised code doesn't use the selection method and I now see that it doesn't apply the True Title macro properly.

Any suggestiins?
Attached Files
File Type: doc True Title All Tables Test.doc (126.0 KB, 10 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
True Title Case for First Row of All Tables Task Indicator - All predecessors complete true/false, y/n jdove78 Project 2 10-10-2012 05:53 PM
IF formula returns TRUE instead of evaluating COUNTIF ColinC Excel 4 12-28-2011 08:21 AM
Another Case of Automatic/Zombie Formatting of Tables MKummerfeldt Word Tables 0 10-31-2011 10:40 AM
True Title Case for First Row of All Tables Macro not staying true oluc Word VBA 4 11-21-2010 08:10 AM
True Title Case for First Row of All Tables From all UPPER CASE to Proper Case davers Word 1 04-30-2009 12:41 PM

Other Forums: Access Forums

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