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
Bookmarks