Relative Speed of Various Processes in Macros

[ransomedbyfire]

I've been researching on how to speed up a macro and have read many things like that activating a worksheet and going back and for between worksheets are slow in macros and that using arrays instead of loops can make things faster. I've also observed that, surprisingly, one of the older macros I made when I was just starting to learn VBA that activates each cell in a column to deposit data runs faster than some of my cleaner looking ones that work more "behind the scenes" to do the same type of things.

Where can I find comprehensive information on which methods are faster than others?

 

[venkat1926]

dont select sheet columns or cells. use "with.....end with" process.

e.g

workssheets("sheet1").select
range("A1").select
selection=1234

instead use
with worksheets("sheet1")
.range("A1")=1234
end with

see the dot before range("A1")