Deleting rows from a structured table based on the value of a column
I'm using the code below to delete rows from a structured table based on a column having a zero value. In the table I have there are 6 rows with a zero value in the "Total" column.
The code deletes four of the rows but doesn't delete the first 2 rows that have a zero in the "Total" column.
For Each tblRow In [OrdersTable].Rows
If (tblRow.Columns(tblRow.ListObject.ListColumns("Tot al").Index).Value) = "0" Then
tblRow.Delete Shift:=xlUp
End If
Next
Anyone have an idea why this code would skip deleting 2 of the rows where the "Total" column is 0?
Thanks
|