Shift row up with clear. Contents

[Ohad1997]

I have a very big excel table, with indexed values for a built in search engine, because of that ordinary delete takes a very long time to proccess, so im using clear. Contents and filter that filter hidden "." next to cells containing a values alphabeticly to clear the empty spaces left after clearing a value, now for my question, the code works great and its much faster then deleting, but is there is a better way to achieve the same result? (clear the empty spaces left after Clear. Contents)

 

[MrTeeny]

The quickest way to deal with large amounts of data is generally to load the data into an array , do your adjustments on the array then write it back to the sheet inn one pass. You could also try turning off screen updating and set calculations to manual whilst the routine runs if your code is writing to the sheet one at a tine in some loop that will speed things up greatly if you have formulas on the sheet.