slow macro

I have a macro that, in one test, finished in under a minute with Excel 2007 and took 13 minutes in Excel 2003. I have narrowed it down to one section of code that takes all the time. Any thoughts? On Error GoTo ErrHandler For x = myRow To lRow Application.CutCopyMode = False...

Currently I am using a worksheet that uses hundreds of hundreds of checkboxes linked to their cells. I find this macro is very long for the amount of times I have to use it and is slowing down my program this is the Macro I am using: Sub AddCheckBoxes() On Error Resume Next Dim c As...

Hi Forum 2007 / XP I have a process which brings emails into a table in Excel (TimeReceived, Sender, Subject, Body, Mail Folder). I have to use MAPI because it is a group mailbox, which cannot be controlled with standard outlook vba like a primary outlook folder. When the macro runs...

Hello I have a macro that opens another workbook and deletes rows based on specified criteria. The code that deletes the rows works fine but runs extremely slow. When I step through it my self it seems to work relatively quick but it gets caught up when its running. Here is the sub program...

I have the following code that is very slow - could someone please advise if there is a way to speed up this function: For Each ws In Worksheets ActiveSheet.DisplayPageBreaks = False With ActiveSheet.PageSetup .CenterHeader = "&A" .CenterFooter = "Page &P of &N"...

Dear frenz, i need a solution to fasten the process of my macro, its taking almost 1 hour to complete the process.....the macro as below Option Explicit Public Function MatchDigits(LookupValue As Range, LookupRange As Range) As String Dim Cell As Range Dim NewNum As String Dim...