Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Macro to delete sheets and saves remaining file does not properly delete module | Excel Programming | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |