This macro helps me to delete the entire rows into a table, when there are empty cells in the column A.
When I use the macro ?
To delete the entire row for empty cells in a table.
How to create the macro ?
Read How to create, edit, hide and select a macro in an excel report
How to create the button to associate it with the macro ?
Read How to create a button and associated it to a macro in an excel report
How is the macro ?
Copy the code below and paste it into your macro. You will see my comments in green if exist so follow the help to adapt to your need.
Dim i As Long
Application.ScreenUpdating = False
' change xxx by the table name
For i = .ListRows.Count To 1 Step -1
If .ListRows(i).Range.Cells(1) = "" Then
Application.ScreenUpdating = True