Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings,
I have a macro which works great. The only thing I need to add is to begin on Row 2. In other words I need to leave Row 1 alone. The macro that I'm currently using is.
Thank you,
I have a macro which works great. The only thing I need to add is to begin on Row 2. In other words I need to leave Row 1 alone. The macro that I'm currently using is.
VBA Code:
Sub Delete_APOE()
Dim R As Integer
For R = Sheet1.UsedRange.Rows.Count To 1 Step -1
If Cells(R, "A") = "APOE" Then
Sheet1.Rows(R).EntireRow.Delete
End If
Next
End Sub
Thank you,