Find and delete range of data

[randell.graybill]

What I need is some code that will do the below code for a range of data with each new search searching the next cell, first pass the if statement checks O5 and then runs the search on N5 to delete the data. The second pass would then check O6 and run the search on N6. The range that would need to be searched and purged would be O2:O750. If anyone has any ideas on how to do this differently I'm open to suggestions, but at the very least if someone could help with what I ask even if it isn't the most effective.

If Range("O5").Value = 1 Then
    Columns("A:J").Select
    Selection.Replace What:=Range("N5"), Replacement:="", LookAt:=xlPart, _
        SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
        ReplaceFormat:=False
End If