general question on code ("A1") versus [A1]

Hi Kade,

They are only interchangeable when the references are literals, i.e., when the string that defines the range or range name is "hard-coded" as opposed to computed. So

[B4] is equivalent to Range("B4"),

but you cannot us the bracketed syntax to accomplish

Range("B" & i)

where i is an integer value representing a row index.

Also, the Range("...") syntax is more efficient (in execution speed) than the bracketed method, although this is only very rarely an issue.

Damon

thanks Damon, this explains why it only worked somtimes for me!

kd

Howdy Kade, love this question, a good one. The brackets are the hard-coded variety of evaluate.

For example:<pre>
[a1].Activate</pre>

Is the equivalent of:<pre>
Evaluate("a1").Activate</pre>

There is much more to them than referencing ranges. For a great, in-depth explanation, I recommend the following post by Monsieur Laurent Longre:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=366730CB.1FB1@wanadoo.fr&rnum=5

IMO, A must read.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-12-09 18:36