View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.newusers
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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