OZmium Sports Betting and Horse Racing Forums - View Single Post

benton, it may make things easier allround to delete out all the place records prior to using bf's data

The code below does the job, let me know if you need instructions on use

Code:

Sub delete_place_records()

Dim lst As Long
Dim i As Long


lst = Range("E" & Rows.Count).End(xlUp).Row


For i = lst To 1 Step -1


    If Range("E" & i).Value Like "TO BE PLACED" Then
        
        Range("E" & i).EntireRow.Delete
        
    End If


Next i
End Sub