PDA

View Full Version : Solved: How to speed-up Macro?



m.azrie
12-10-2006, 05:31 PM
Hi there,
Anyone can help me how to speedup my macro in excel file which contains formula cells, link chart and etc:think: .

i try add ...
"Application.Screenupdating = False"

but processing still slow:( .
Is it any code to speed the process?: pray2: ..


Thanks,

Bob Phillips
12-10-2006, 05:36 PM
Application.Calculation = xlCalculationManual

'your code

Application.Calculation = xlCalculationAutomatic


Also, if you are selecting cells, that is inefficient and unnecessary.

m.azrie
12-10-2006, 06:06 PM
xld,

I tried, but my process still slow :( ....
is that any way i can do?.

Thanks anyway....
:help

tpoynton
12-10-2006, 06:35 PM
there is an excellent article (http://vbaexpress.com/forum/showthread.php?t=9882) in the articles section of this forum

JimmyTheHand
12-11-2006, 03:31 AM
You could also upload the code, if it's not classified. Someone here might be expert enough to optimize it.

MrRhodes2004
01-16-2007, 10:36 AM
there is an excellent article (http://vbaexpress.com/forum/showthread.php?t=9882) in the articles section of this forum

When I click the link:
Invalid Article specified. If you followed a valid link, please notify the administrator (http://vbaexpress.com/forum/sendmessage.php)

lucas
01-16-2007, 10:46 AM
It worked for me MrRhodes....

Carl A
01-16-2007, 11:00 AM
Link is invalid

Invalid Article specified. If you followed a valid link, please notify the administrator (http://vbaexpress.com/forum/sendmessage.php)

Bob Phillips
01-16-2007, 11:08 AM
There are a few in there.

johnske
01-16-2007, 02:17 PM
try http://xlvba.3.forumer.com/index.php?showtopic=18 instead