Trying to Delete only Table Rows-VBA

[ESPN8]

Hello Everyone.

I am using a macro to import data from other sheets in my workbook to a table. I am then using another code to delete rows with zero in column "E". The problem I am having is that it is deleting the entire row from the sheet, not just the table row. I have other information I need to stay static next to the Table. I only want to delete the table row not the entire sheet row.

Current Code is below:

Sub DELETE_ZERO()

last = Cells(Rows.Count, "A").End(xlUp).Row 'Delete rows
For i = last To 2 Step -1
If (Cells(i, "E").Value) = 0 Then
Cells(i, "T").EntireRow.Delete
End If
Next i
End Sub



Any help would be appreciated.

Thank you!

 

[ESPN8]

@Akuini I saw my typo and tried it both ways and got the same error both times. MickG's solution worked out for me.