Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Looking for suggestion on how to change the following as required,
to greatly improve speed of operation. Without the following: about 5-6 seconds WITH the following: about 30 seconds. Dim LastRow As Long Application.ScreenUpdating = False LastRow = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row For RowNdx = LastRow To 1 Step -1 If Cells(RowNdx, "B").Value = "x" Then Rows(RowNdx).Delete End If Next RowNdx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 speed up printer | Excel Discussion (Misc queries) | |||
calculation speed of Excel 2003 and Excel 2000 | Excel Discussion (Misc queries) | |||
Speed VBA Excel 2003 vs 2007 | Excel Programming | |||
Trendline Properties/Deletions in Excel VBA | Excel Programming | |||
Speed--Excel 2003 RAND vs. VBA Rnd... | Excel Programming |