Want to reduce Macro running time

[rvkadu1]

I have macro script, which is working well be said file taken much time to execute,

please help me to reduce time of execution.

Ravi
===

Please Login or Register  to view this content.

====

[Ed_Collins]

Ravi,

I don't know your level of expertise, but did you try putting

Application.ScreenUpdating = FALSE

at the very beginning of your code and then

Application.ScreenUpdating = TRUE

at the very end?

[Ed_Collins]

Also, you don't have to first select a cell to change its value. You can change it directly, without selecting it.

For example, if you want "contractorcode" in Cell A1, then instead of

Range("A1").Select
ActiveCell.FormulaR1C1 = "contractorcode"

just

Range("a1") = "contractorcode"

will work fine and from what I've read, will be faster.

[Ed_Collins]

Here's a couple of websites that have a few good tips on optimizing vba macros.

http://chandoo.org/wp/2012/03/22/vba...on-techniques/
http://www.ozgrid.com/VBA/SpeedingUpVBACode.htm