Hello,

I notice there is another thread on this, not sure if i should combine it as it stated [solved].

My script is running perfectly, but when i add this code in the script,

 'Delete rows that have nothing balances on Column W
    Dim Rng As Range, ix As Long
    Set Rng = Intersect(Range("W:W"), ActiveSheet.UsedRange)
    For ix = Rng.Count To 1 Step -1
    If Rng.Item(ix) = "" Then
    Rng.Item(ix).EntireRow.Delete
    End If
Next

    Range("Q13").Select
the script continues to run without stopping. When i choose to debug, it will highlight my End If.

Could someone advise me what is wrong with my code?

Thanks in advance.

Cheers