Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a couple of macros that sort through db output and delete
unwanted information Example: Do while selection < "" if selection 100 hours then selection.entirerow.delete else offset to next row endif loop Two questions: First, is there a faster way to do this, i.e. sort for greater than 100 and delete the results? Second, on one sheet that only has three columns this runs very fast. (28k rows in about 15 minutes) but on another sheet with about 35 columns it only does about 2 rows a second. What is causing such a vast difference in speed? Is it the number of columns deleted during the entirerow.delete line? Thanks for the help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Question on Calculation Speed | Excel Discussion (Misc queries) | |||
vlookup speed question | Excel Worksheet Functions | |||
Re-calc. speed question | Excel Worksheet Functions | |||
Question to speed up a process - | Excel Programming | |||
VBA Speed question | Excel Programming |