Thread: delete row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] fi.or.jp.de@gmail.com is offline
external usenet poster
 
Posts: 51
Default delete row

i am using this code to delete the rows if its value is true

This slow, It process at speed of 7 Minute per 1000 rows

I am using below code

Sub remove()
Worksheets("sheet3").Range("G2").Select
Rng = Cells(Rows.Count, "C").End(xlUp).Row
starter = Timer
For i = 1 To Rng
If Cells(i, 7).Value = False Then
Rows(i).Delete
Else
End If
Next
MsgBox Format(Timer - starttime, "00:00:00")
End Sub