Hi all,
I use this Macro:
This code takes very long (20 minutes).![]()
Sub del() Sheets("TariefDisplay").Select Dim r As Integer, tot As Integer With Sheets("TariefDisplay") tot = .Range("A234").CurrentRegion.Rows.Count + 20000 For r = tot To 234 Step -1 If .Cells(r, 1) = "" And .Cells(r, 17) = "" _ Then _ .Rows(r).Delete Next r End With End Sub
is there a possibility to speed up this code?
Regards,
Danielle
Bookmarks