Jump to content

Copy and Pasting rows in Excel takes WAY TOO LONG


Recommended Posts

I have a VBA script connected to a macro that copies rows from one sheet to another in my excel workbook. However, this macro is so slow, and takes 100% of my CPU that I have to pull the battery to get it to stop. Below is the code that seems to be so slow.

does anyone have different code I can use, or can help with this ?

thanks in advanced.

Sub TransferLine(rcnt As Long, trcnt As Long)


Sheets("CalculatedPlan").Rows(trcnt).PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False

End Sub

I can provide the entire macro, if one needs to see that

Again, thanks for any help !!

Link to comment
Share on other sites

  • 2 weeks later...

Are you trying to copy a compete row if so try this

Sub copyrow()


' change the above row to the one you want to copy



' change the "sheet2" to the sheet you want to copy to



End Sub

this will take a fraction of a second

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    • No registered users viewing this page.

  • Create New...