Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-02-2018, 02:30 PM
fbucaram fbucaram is offline Delete all empty rows in all tables Windows 10 Delete all empty rows in all tables Office 2016
Novice
Delete all empty rows in all tables
 
Join Date: Jan 2018
Posts: 3
fbucaram is on a distinguished road
Smile Delete all empty rows in all tables

Hi,

I am using the following macro to delete all rows in all tables of a word document:

Code:
Option Explicit

Public Sub DeleteEmptyRows()

Dim oTable As Table, oRow As Range, oCell As Cell, Counter As Long, _
NumRows As Long, TextInRow As Boolean

' Specify which table you want to work on.
For Each oTable In ActiveDocument.Tables
' Set a range variable to the first row's range
Set oRow = oTable.Rows(1).Range
NumRows = oTable.Rows.Count
Application.ScreenUpdating = False

For Counter = 1 To NumRows

    StatusBar = "Row " & Counter
    TextInRow = False

    For Each oCell In oRow.Rows(1).Cells
        If Len(oCell.Range.Text) > 2 Then
            'end of cell marker is actually 2 characters
            TextInRow = True
            Exit For
        End If
    Next oCell

    If TextInRow Then
        Set oRow = oRow.Next(wdRow)
    Else
        oRow.Rows(1).Delete
    End If

Next Counter
Next oTable
Application.ScreenUpdating = True

End Sub
It is working, however, all the columns that have empty rows end up opening very wide (see attached pic).



Can somebody please give me a hand?
Attached Images
File Type: jpg a.jpg (194.5 KB, 32 views)

Last edited by fbucaram; 01-03-2018 at 11:38 AM. Reason: add pic
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Delete all empty rows in all tables Delete Empty Table Rows cltay87 Word VBA 4 02-27-2017 04:23 AM
Delete all empty rows in all tables Macro to delete all empty rows from all tables braddgood Word VBA 15 10-02-2015 01:54 PM
Delete all empty rows in all tables Delete blank rows between the two rows that contain data beginner Excel Programming 5 12-26-2014 12:29 AM
Delete all empty rows in all tables Delete All empty Rows - Print - Undo all Rows deleted Bathroth Word VBA 1 10-01-2014 01:40 PM
Delete all empty rows in all tables Macro to delete rows with all empty cells ubns Excel Programming 2 08-14-2012 02:01 AM

Other Forums: Access Forums

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