Macro deleting top-down or bottom-up?

[katekoz]

Is this macro deleting rows from the top down, or from the bottom up? How can you tell?

For r = ThisWorkbook.Sheets("New Data Add").UsedRange.Rows.Count To 1 Step -1
If Cells(r, "F") = "Status History" Then
ThisWorkbook.Sheets("New Data Add").Rows(r).EntireRow.Delete
End If
Next

 

[CSmith]

That looks bottom up

 

[katekoz]

Awesome, thanks! Is it because it goes from the last row to row 1? If you wrote it from 1 to last row, would that change the order that it runs?

Also, does Step -1 indicate stepping up, whereas Step 1 would step down?

 

[Michael M]

Is it because it goes from the last row to row 1? Yes

If you wrote it from 1 to last row, would that change the order that it runs? Yes, but it wouldn't work correctly

Also, does Step -1 indicate stepping up, whereas Step 1 would step down? Yes, but you don't need the Step if you are stepping down, only stepping up

And you could use

For r = Sheets("New Data Add").UsedRange.Rows.Count To 1 Step -1
If Cells(r, "F") = "Status History" Then.Rows(r).Delete
Next r

 

[katekoz]

Great, thank you both!!