I created a macro to delete an entire row in an Excel
spreadsheet based upon a specific given condition. I've seen a few others
code for this same problem and I thought they overthought it and wrote
a unnecessarily long code. Here is my quick and easy solution. Let's say
I have a few cells in column A named "FINAL_BODY" where I want
to delete the entire row.
Sub Delete_FINALBODY_Rows()
Dim r As Long
For r = Range("A" & Rows.Count).End(xlUp).Row to 1 Step -1
If UCase(Left(Cells(r, "A").Text, 10)) = "FINAL_BODY" Then Rows(r).Delete
Next r
End Sub
Sub Delete_FINALBODY_Rows()
Dim r As Long
For r = Range("A" & Rows.Count).End(xlUp).Row to 1 Step -1
If UCase(Left(Cells(r, "A").Text, 10)) = "FINAL_BODY" Then Rows(r).Delete
Next r
End Sub
No comments:
Post a Comment
I'd love to hear from you!
-Nick