| Home |
| Search |
| Today's Posts |
|
#12
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Adding a loop to conditional delete code
Steve,
Putting them back is trivial. If it is important, you simply re-sort on another column, or if there isn't a column to base the sort on, you add another column through with the original row number to allow re-sorting. But the speed gain can be up to 1000 times, given testing that I have done previously. Bernie MS Excel MVP "SteveW" wrote in message news:op.tebvu5srevjsnp@enigma03... Neat. Now put the other rows back where they were :) Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit this macro code to loop and end | Excel Discussion (Misc queries) | |||
| Code to delete rows and column cells that have formulas in. | Excel Worksheet Functions | |||
| bar code help, adding asterix to reference | Excel Discussion (Misc queries) | |||
| Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
| VBA Newbie: Help with Do Loop code | Excel Discussion (Misc queries) | |||
Threaded Mode
