This problem has been on mind for a while and I haven't read anything concreate about it so I thought I would poll the people here. How can we force a macro to use all our CPU capacity when running? I am running a quad-core, 64-bit Excel and my macros seem to only use around 25% of the avaiable CPU capactity. On the other hand, if I update a million cells with formulas in them, Excel flexes its musceles and sucks every last drop of processing capacity to its favor. Any thoughts? Has anyone come up with a way to simulate multithreading with vba?
abousetta
Bookmarks