Hello,
I have a large dataset and trying to filter and clean some junk records from it as part of a macro.
Current method is to loop through each row and delete if it's junk - this is taking too much of time and wondering if there is any efficient way.
Here is a the snapshot of the code-
'Loop from the Lastrow to Firstrow (bottom to top)
For Lrow = Lastrow To Firstrow Step -1
'We check the values in the "O" column and delete if the WS_Load percent is 0
With WSP.Cells(Lrow, "O")
If .Value = 0 Then .EntireRow.Delete
End With
Next Lrow
Appreciate you help.
Thanks, Anil
Bookmarks