Hello,
I have this table and I want to delete all the table rows that are empty. The problem comes in when I am trying to delete the "Table Row" and not the excel entire row. There is data next to my table and I don't wanna mess it up.
This is the code I managed to put togeter
[vba]Sub Delete_Empty_Rows_Table()
Dim i As Variant
Dim varWorkbook As Workbook
For Each i In varWorkbook
Set i = ListObjects.ListRows.Count
If Range("B7:B10000").Value = "" Then
Selection.ListObject.ListRows(i + 1).Delete
End If
Next i
End Sub[/vba]