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,
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,
Mohd Azrie
Bt Pahat, Johor, Malaysia.
[vba]
Application.Calculation = xlCalculationManual
'your code
Application.Calculation = xlCalculationAutomatic
[/vba]
Also, if you are selecting cells, that is inefficient and unnecessary.
xld,
I tried, but my process still slow ....
is that any way i can do?.
Thanks anyway....
Mohd Azrie
Bt Pahat, Johor, Malaysia.
there is an excellent article in the articles section of this forum
You could also upload the code, if it's not classified. Someone here might be expert enough to optimize it.
When I click the link:Originally Posted by tpoynton
Invalid Article specified. If you followed a valid link, please notify the administrator
It worked for me MrRhodes....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Link is invalid
Invalid Article specified. If you followed a valid link, please notify the administrator
There are a few in there.
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.