I have this simple loop designed to look at a block of data in excel:
it firstly identifies how many rows it extends down - this defines the number of iterations
then on each row N, looks to see if the cell(N,B) is empty - if so deletes that row.

This seems to not work, also it takes ages! I need something that does this very quickly.

Any thoughts would be aprreciated

```
Sub PREBILLvariant2()

        Dim N As Long

 For N = 1 To Worksheets("EMEA input").Cells(Rows.Count, "A").End(xlUp).Row

If InStr(Cells(N, "B").Value, "") > 0 Then Worksheets("EMEA input").Cells(N, "B").EntireRow.Delete

    Next N

    End Sub

```