Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 11-21-2022, 06:26 AM
gmayor's Avatar
gmayor gmayor is offline Vba word macro erase rows from tables Windows 10 Vba word macro erase rows from tables Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The first part can easily be achieved using Document Batch Processes with the following custom process. The second part would require more information about what to look for and what to replace it with.

Code:
Function FixTable(oDoc As Document) As Boolean
Dim oTbl As Table
Dim i As Long
    On Error GoTo Err_Handler
    For Each oTbl In oDoc.Tables
        For i = oTbl.Rows.Count To 1 Step -1
           Select Case i
            Case 2, 3, 4
                oTbl.Rows(i).Delete
            Case Else
           End Select
        Next i
    Next oTbl
    FixTable = True
lbl_Exit:
    Exit Function
Err_Handler:
    FixTable = False
    Resume lbl_Exit
End Function
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
 

Tags
macro, mail merge, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro type check columns of multiple tables - return mismatch rows zizz Excel Programming 3 08-28-2021 09:26 PM
How do I on MS Word VBA add and remove rows in the tables using command button macros? ananas1171 Word VBA 6 06-30-2021 07:51 AM
VBA color of visible gridlines of tables word (with some merged cells in first rows) Alvaro.passi Word VBA 0 07-18-2017 09:11 AM
Vba word macro erase rows from tables Word 10 Tables: Column to auto number 1.1, 1.2 etc in sequential rows FrauBaker12 Word Tables 7 06-24-2016 11:52 PM
Vba word macro erase rows from tables Macro to delete all empty rows from all tables braddgood Word VBA 15 10-02-2015 01:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:10 AM.


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