Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 12-08-2021, 09:30 PM
Bikram Bikram is offline Need a macro adjustment Windows 10 Need a macro adjustment Office 2007
Advanced Beginner
 
Join Date: Jul 2021
Location: Nepal
Posts: 97
Bikram is on a distinguished road
Default

Dear ULOdesk, You can use the following code to target tables that are wrapped around text.
Code:
Sub Formattingtables()
    Dim i As Integer
    Dim ii As Integer
    Dim doc As Document

        Set doc = ActiveDocument
            ii = doc.Tables.Count
        For i = 1 To ii
            If doc.Tables(i).Rows.WrapAroundText = True Then
                'Ignore the wrapped Tables
            Else
                'Apply formatting to Non - wrapped Tables
                With doc.Tables(i)
                    .AutoFitBehavior wdAutoFitFixed
                    .PreferredWidthType = wdPreferredWidthPoints
                    .PreferredWidth = InchesToPoints(7.2)
                    .Rows.Alignment = wdAlignRowLeft
                    .Rows.LeftIndent = InchesToPoints(0.3)
                End With
            End If
        Next
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a macro adjustment Macro adjustment needed Ulodesk Word VBA 2 02-06-2020 06:49 AM
IF Statement Adjustment shawn.low@cox.net Mail Merge 0 09-23-2019 10:08 AM
Can I disable auto adjustment of sizes in Smart art Hierarchy charts? frankgoldman PowerPoint 1 05-04-2019 04:37 AM
Need a macro adjustment Automatic adjustment date zbiku25 Project 3 02-28-2017 09:03 AM
Need a macro adjustment Table adjustment on Surface OneNote TheMax OneNote 1 01-23-2015 04:33 PM

Other Forums: Access Forums

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