Thanks for that definite response!

--
AP

"Chip Pearson" a écrit dans le message de
...
The contents of the [] characters are evaluated at run time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ardus Petus" wrote in message
...
I thought VBA was compiled before execution.
If true, how come one method is faster than the other?

TIA

--
AP

"Chip Pearson" a écrit dans le message de
...
Using the [] method is slower than second method. I always use
the second method, though that is a matter of personal
preference.


"Ardus Petus" wrote in message
...
Since I found out yo may write
[Sheet2!A1:b2].value
instead of :
Worksheets("Sheet2").Range("A1:B2").Value

I would like to know wether this is bad practice or just a
performance issue

TIA

--
AP