View Single Post
 
Old 08-17-2017, 11:41 AM
nasserlouis nasserlouis is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Aug 2017
Posts: 6
nasserlouis is on a distinguished road
Default problem with deleting empty rows MS Word VBA

Hello;
I have this microsoft Word file i need to :

1_ delete empty rows with this macro
------------------
Code:
 
Sub DeleteBlankTableRows()

Dim deleted As Boolean
Dim oRow As Row

deleted = False

On Error Resume Next
ActiveDocument.Tables(1).Select
If Selection.Information(wdWithInTable) = False Then
    MsgBox "No table exists in the document!", vbCritical, "Error"
    Exit Sub
End If

For Each oRow In Selection.Tables(1).Rows
    If oRow Is Nothing Then
        MsgBox "The tool cannot work in this table. This might be because one or more rows have merged cells. If these merged cells are removed, it will probably work.", _
        vbCritical, "Error"
        End
    End If
     If Len(oRow.Cells(2).Range.Text) = 2 Then
   'Or If InStr(oRow.Range.Text, "") > 0 Then
        oRow.Delete
        deleted = True
    End If
Next oRow

If deleted Then
    MsgBox "All Blank lines have been deleted.", vbOKOnly, "Success!"
Else
    MsgBox "No Blank lines containing *To Be Deleted* text can be found.", vbOKOnly, "Failure!"
End If

End Sub
-------------------------
the problem is the macro code delete those (see the picture) rows that i don't want to be deleted



2_ i want to use that macro to delete empty rows for all 100 tables with the same construction.

Thank you
Attached Images
File Type: png vbaProblem.png (58.8 KB, 24 views)
Attached Files
File Type: docx onetable.docx (26.0 KB, 23 views)

Last edited by nasserlouis; 08-17-2017 at 04:13 PM. Reason: solved
Reply With Quote