I have this in my macro and it goes through and finds the text blankerror and deletes that row. Only problem is it takes too long. Is there away to do that without using a loop? or do i just need to name the range. The range that blankerror exists in is B2:B100 .. not anywhere else in the sheet....


what = "blankerror"
      Do
        Set rng = ActiveSheet.UsedRange.Find(what)
        If rng Is Nothing Then
            Exit Do
        Else
            Rows(rng.Row).Delete
        End If
    Loop