Excel vba Sheets.rows.cut vs sheets.rows.copy

Eric B 1 Reputation point
2020-12-22T22:13:46.84+00:00

Within my workbook I have several sheets and am moving data from one sheet to another through

Sheets("Master").Rows(i).Cut Destination:=Sheets(Sheet_Name).Range("A" & Sheet_Row_Num)

My problem is that the .cut command takes 10 second to cut and paste a single line but when i use .copy instead it only takes a fraction of a second. I have removed all the filters and hidden lines in the workbooks.

So why does cut take so much longer? I would prefer to cut the data out so that i know it has been moved to the other sheet.

Thanks

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,680 questions
0 comments No comments
{count} votes