run macro faster

zakir_vjti20

New Member
Joined
Jul 25, 2010
Messages
3
Hi all,

I want to know that ho to run macros faster (2 to 3 times the usual speed) in excel for retrieving data from a web page and copying in excel sheet.

Thanking u.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Most common technique is to turn off ScreenUpdating at the start of your macro, turn it back on when the macro is done.

Else, post your macro and let us take a look.
 
Upvote 0
You could set calculation to manual.

Mind you using either suggestion might not make any difference at all, the problem could lie elsewhere and be nothing to do with the code.:)
 
Upvote 0
how to run macros faster (2 to 3 times the usual speed)
How fast your code executes depends on a number of factors.
The code itself (what all it's doing), the memory & processing speed of your particular machine, what other applications are running at the time, etc, etc.

So... the speed at which it runs can vary noticeably, even on the same machine. There is no way I've ever heard of to actually speed things up, but (as jbeaucaire & Norie point out) there are default settings that slow it down which can be turned off.

And then lastly, it could be the code itself can be rewritten to run more efficiently, which may be able to cut its run time some.
 
Upvote 0

Forum statistics

Threads
1,211,862
Messages
6,104,440
Members
447,909
Latest member
isadayan16

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