Could someone help me revamp this:
My current test spreadsheet has four rows (all of which should be deleted by this), but it only deletes two of them. I suspect the reason for this is because it's looping from the top down, rather than the bottom up. I just don't know how to re-write the code above so that it loops from the bottom up. I've found plenty of examples on how to do this with a regular range, but I can't find anything on how to do it in a table. Any suggestions would be greatly appreciated.
HTML:
Dim c As Range
For Each c In Range("Table1[Entity Code]")
If c.Value = "R" Or c.Value = "T"
Then c.EntireRow.Delete
End If
Next
My current test spreadsheet has four rows (all of which should be deleted by this), but it only deletes two of them. I suspect the reason for this is because it's looping from the top down, rather than the bottom up. I just don't know how to re-write the code above so that it loops from the bottom up. I've found plenty of examples on how to do this with a regular range, but I can't find anything on how to do it in a table. Any suggestions would be greatly appreciated.