I already have screen updating, calculation, and display alerts disabled. There are no event macros in the subject sheet. Status bar is not displayed.
So my 6-second cut and paste is after disabling all of these things.
I already have screen updating, calculation, and display alerts disabled. There are no event macros in the subject sheet. Status bar is not displayed.
So my 6-second cut and paste is after disabling all of these things.
this is the best result in my case.
below is more faster than use "Cut" or "Copy" method.![]()
Sub fsd() FoundRow = 1 Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.CutCopyMode = False old = Timer For i = 1 To 100 Cells(FoundRow + i, 1).Cut Cells(FoundRow + i, 2) Next MsgBox Timer - old & " Sec" Application.ScreenUpdating = True Application.Calculation = xlCalculationAutomatic End Sub
Sheet2.Range("B1:B10").Value= Sheet1.Range("A1:A200").Value
Sheet1.Range("A1:A200").ClearContents
Last edited by chronjy; 12-10-2021 at 02:16 AM.
Caring environment and nature. caring you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks