 ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 556 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Does prioritization of processes helpHi, I run various VBA simulations within Excel. My question is as follows: I noticed that some process managers allow the reprioritizing of processes, e.g. “IObit Process Manager”. The default priority for an Excel instance is “Normal”. If I change this to a higher priority (“Above Normal”, “High”, “Realtime”) what benefit if any can I expect. Thanks. |
Highest Ranked Users
Last viewed:Recent Blogs
ForumsRecent comments
User login |
Optimising VBA speed
Hi Timbo...
Surprised that no-one else has chipped in... anyway, here are my thoughts..
I've not noticed any improvement in VBA speed or stability by changing the priority of processes. In my view, it makes no noticeable difference.
decent ways to speed up VBA code:
1. turn off screen updating
2. turn off events
3. turn off automatic calculation
4. load all ranges into arrays and work with arrays
5. paste values of any formulae whose results are not expected to change during process running
6. play with threading in the Excel options
7. get a faster machine
Nick