LinkBack URL
About LinkBacks
hputhraya 
Hi,
I have been experiencing that a macro runs much slower in excel 2007 compared to excel 2003. Is there any reason for that? And can we do anything to make it run faster?
Regards
Harsha
Hi,
I have been experiencing that a macro runs much slower in excel 2007 compared to excel 2003. Is there any reason for that? And can we do anything to make it run faster?
Regards
Harsha
Re: macro runs much slower in excel 2007
Hi Harsha,
Try the below options, this might speed up the execution a bit.
Sub Test() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual DoEvents End Sub
Last edited by teylyn; 03-25-2010 at 03:55 AM. Reason: removed quote and cleaned up font
Cheerz,
~Ne@l
*********************************************************************
Save a tree. Please think before you print this post and/or attachments.
nchavan: save a mod from heart attack. Please think before you quote whole posts and create unneccessary forum clutter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks