Hi, I am running a very simple macro to rearrange data in a large worksheet (70K+ rows). Problem: When I do a simple cut and paste (of ONE CELL, to move it up ONE ROW!!) that takes about 6-7 SECONDS for each individual cut and paste!! What is going on??? I tried turning calculation to manual - no change. The cell that is being moved contains text ("yes" or "no") and it has no dependents (nor does the cell it is being pasted into). Why in the world does it take so long for a SINGLE-CELL CUT AND PASTE?
Code is simply:
This one line of code takes 6 or 7 seconds to execute!![]()
DataSheet.Cells(FoundRow + counter, 8).Cut DataSheet.Cells(FoundRow + counter - 1, 8)
Bookmarks