macro speed

I have created a macro that cycles through a list of input variables from 2 separate tables. It copies input variables into 2 specific cells (C19 & C22). This action calculates a new value in cell C14 and that value is then copied and pasted into a table (E58:O69). Then it loops to the next 2...

i have a program which has few sheets very hidden, my program is running very slow and hence i am using following code at the start of the Sub or Private Sub Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.DisplayStatusBar = False...

I Use a 1200 line module code for 22 commandbutton. when click each one of button, it fulfill 10 cell value. But it is too slow. is there a way to optimize code? this is one of 22 button code: Sub Iron_Condor() ' ' Iron_Condor Macro ' ' Range("R38").Select ActiveCell.FormulaR1C1 =...

Hi, I read in several post on internet about speeding up the macro based excel programs. I adopted the following procedure and as recommended added these lines in every macro. however still i feel the speed is very less although it depends upon several factors besides correct coding to which i...

Hi Group, I have finally completed my code that is currently looping on 641 Rows of data and its taking exactly 5Mins.... I know this doesn't sound too bad but it is taking waaaaay to long. I am looking for some improvements or for some modifications to shorten or help speed up what I am...

32 bit Excel 2013 installed on a Windows 7 64-bit machine. What are the limitations? It seems my macro's do not execute as fast. If I understand correctly, with 64 bit Excel can use 4 processors for performance, while 32 bit is limited to 2?? Anyone more knowledgable about this let me know if...

I have a macro that runs for approximately 90 Sales Rep files. The macro itself runs fairly quick but I have noticed that I am unable to do anything while the macro is running due to Excel Automatic Calculate will use 100% of the CPU Usage throughout the macro. I have to calculate the...

I have some Excel 2003 Macros that run 5 or 6 times slower in Excel 2007 / 2010. (Not sure how Microsoft accomplished such a wonderful feat!) That speed is just not acceptable. PLEASE Does anyone have any pointers for me on how to speed it up? THANKS! ----------------------------- Sub...