Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 05-02-2023, 09:37 AM
adamyawn adamyawn is offline Table formatting- column widths to percent Windows 10 Table formatting- column widths to percent Office 2021
Novice
 
Join Date: May 2023
Posts: 1
adamyawn is on a distinguished road
Default Update On This Code

I know this post was created ages ago, but it's worth noting that this line

.Columns(i + 1).PreferredWidth = ...

works better as

.Columns(i + 1).Width = ...

in terms of sizing each column. Thank you for sharing this code with everyone!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Splitting one column into two with two different widths officeboy09 Excel 6 12-15-2013 09:48 PM
Adjusting column widths norwood Word VBA 0 09-24-2013 06:53 AM
Table formatting- column widths to percent VBA code to fix column widths molesy Excel 3 09-16-2013 12:51 PM
Table formatting- column widths to percent Alternate Table Column Widths on even and odd pages robrastelli Word 4 08-08-2012 07:33 PM
Table formatting- column widths to percent Altering Column Widths on Two Col Page abrogard Word 2 12-30-2010 06:03 AM

Other Forums: Access Forums

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