Solved: How to speed-up Macro?

[m.azrie]

Hi there,
Anyone can help me how to speedup my macro in excel file which contains formula cells, link chart and etc .

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

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


Thanks,

[Bob Phillips]

[vba]

Application.Calculation = xlCalculationManual

'your code

Application.Calculation = xlCalculationAutomatic
[/vba]

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

[m.azrie]

xld,

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

Thanks anyway....

[tpoynton]

there is an excellent article in the articles section of this forum

[JimmyTheHand]

You could also upload the code, if it's not classified. Someone here might be expert enough to optimize it.

[MrRhodes2004]

there is an excellent article 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

[lucas]

It worked for me MrRhodes....

[Carl A]

Link is invalid

Invalid Article specified. If you followed a valid link, please notify the administrator

[Bob Phillips]

There are a few in there.

[johnske]

try http://xlvba.3.forumer.com/index.php?showtopic=18 instead