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