Jump to content

keithweinberger

Member
  • Posts

    1
  • Joined

  • Last visited

  • Donations

    0.00 USD 
  • Country

    United States

Everything posted by keithweinberger

  1. 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("ProjectPlan").Rows(rcnt).Copy 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 !!


×
×
  • Create New...