Increase "CPU Usage" when running macro

alextang0112

New Member
Joined
Oct 31, 2012
Messages
35
Hi guys,

My PC is Win7 64bits, Office 2010 Professional, i7-930 4C8T CPU.

I run a macro in VBA, and the macro consist of 3000 loops with each loop varibles starting from 0 to 15000.

The information of CPU usage in windows task manager always shows about 30% when the macro is under way.

The time it cost is about 12mins.

I'm trying to find any informantion about how to make my PC work more efficiently (raise the CPU usage).

But it seems that the number of supported threads in VBA is only one.

Is that true ? Or actually there exist any setting that can boost the cpu usage when running macro ?

Thanks.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top