Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 12-10-2013, 07:47 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: 102
Marrick13 will become famous soon enough
Default True Title Case for First Row of All Tables

Paul,

Thanks for the update and the Proper Case macro (I'll try that sometime). I was intending for the True Title macro only for single sentence and single line text in the first row of each table, but I appreciate he completeness of your efforts. However, now I'm seeing that if the first letter of the text is one of the array items, the revised macro makes it lower case. The original True Title code had a snippet that addressed this by detecting the first letter and applying upper case:

.MoveEnd Unit:=wdCharacter, Count:=-Len(sText) + 1
.Case = wdUpperCase

I've attached the test file with two examples in the first two tables, both of which begin with "A" but become "a" when the revised macro runs. Is this a simple fix? I don't want you spending much more time on this!
Attached Files
File Type: doc True Title All Tables Test.doc (135.5 KB, 9 views)
Reply With Quote
 



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 12:23 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