slow macro 2007

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...

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...

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)-...

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...

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...

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...