slow macro 2007

  1. J

    Compare rows between 2 sheets - slow

    Hi, This works but can anyone think of a way to make it faster? It needs to look through over 15,000 rows. Set Sh_1 = ActiveWorkbook.Sheets("NFC Allocations") Set Sh_2 = ActiveWorkbook.Sheets("RSL") For r = 2 To Sh_1.UsedRange.Rows.Count For s = 2 To...
  2. J

    Slow open/save times

    I have a XLSM file that I made that take around 45 seconds to 1 min to open and I am not sure why or how I could speed things up. The file is 6 MB, uses 4 different custom user forms running some code, and has 12 tabs that have two columns of array formulas each down to row 5000. I figured...
  3. A

    How to speed up Macro?

    Hi, Without much experience, I have written a macro which does exactly what i want it to except it takes a long time to process. Could someone please help me simplify & speed up this 'mess' that is my macro? Thank you! Sub Macro7() ' ' Macro7 Macro ' 'Quite a complicated macro (for me)-...
  4. M

    Consolidation Macro runs too slow

    I have built a macro to consolidate three unsimilar worksheets into one worksheet. Bascially the macros takes some information from an individual worksheet and adds data from the other worksheets based on the match of an item number (deal number in this case). I've tested a few times and seems...
  5. D

    Macro slows down and then grinds to a halt please help

    I have a macro that I have built to copy ranges and charts. The ranges one works great. The chart one works great as well. It duplicates the chart including the title, logos, text boxes and allows for the ranges and axis to be uniqly updated as well by simply offsetting the ranges and axis rows...
  6. D

    Slow macro in 2007 - runs fast in 2003

    This code takes 40 seconds to run in 2007 but <1 second in excel 2003. Why? How can I make it run faster? Thank you in advance! For RowCount = 1 To 1800 If ActiveCell.Value = 0 Then ActiveCell.EntireRow.Hidden = True ActiveCell.Offset(1, 0).Activate...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top