is [A1] faster than Range("A1").select

[JeffGrant]

Hi All,

I have read this article: http://excelitems.com/2010/12/optimi...er-macros.html

where it states that to speed up macro processing, it is better to use [A1] than Range("A1").

Does [A1] make the compiler faster because it does not have to resolve the Range("A1") reference?

Where Application.Screenupdating = False stops the compiler from repainting the screen.

So these are two very different components but will have a combined effect in decreasing processing time.

Am I on the right track in my thinking?

Thanks

[romperstomper]

[A1] is not faster - the Range("A1") syntax should be faster. You could simply time it yourself.

Screenupdating will have a much bigger effect though.

[Richard Buttrey]

On the subject of speeding up macros, try and avoid loops which do something in the Excel App each pass through the loop. Instead read the data yuo want to process into a VBA array and process that with the loop and only write the array back to Excel when the loop is complete.