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

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

jbeaucaire

Well-known Member
Joined
May 8, 2002
Messages
6,012
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.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,344
Office Version
  1. 365
Platform
  1. Windows
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.:)
 

HalfAce

MrExcel MVP
Joined
Apr 6, 2003
Messages
9,456
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,043
Messages
5,835,088
Members
430,340
Latest member
xoxe1337

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
Top