Find and Delete Rows...Noob to Excel

[CuriousEW]

I have reviewed all the posts, and found the VBA code to be very confusing when finding and deleting rows with a specific value. I am very new and could use some guidance.

The value of "Valassis Inc" I want to find are in one column. I want to delete the rows containing this value and clean up the deleted rows once complete.

Is this possible for someone with NO VBA experience? If not, where can I read up on VBA code?

Thank you.

 

[VoG]

The code would be like this

Sub DVAL()
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = LR To 1 Step -1
    If Range("A" & i).Value = "Valassis Inc" Then Rows(i).Delete
Next i
End Sub

 

[Trevor G]

Welcome to the Forum,

Try this

Sub test()
Dim LastRow As Long, i As Integer

LastRow = [A65536].End(xlUp).Row
For i = LastRow To 1 Step -1
If cells(i, 1) = "Valassis Inc" Then Rows(i & ":" & i).EntireRow.Delete
Next i
End Sub

 

[CuriousEW]

Since the value I am looking for was in Column R, I changed "A" to "R" and all worked well. Couldn't get it to run with "A" in the LR value and IF statement. Not sure if this was the best practice, but it seemed to do the trick.

Thanks to all who offered guidance!!!

I am sure you will hear from me again :P