Deprecated [...]

  • Thread starter Thread starter Bruno Campanini
  • Start date Start date
B

Bruno Campanini

I posted this on microsoft.public.excel but I didn'n
get any opinions yet.
May be I'll be more this side...
--------------------------------------------------------------
What's about MS "deprecated" notation [Sheet2!B5]?
I'm using that notation as it is much simpler to write
than Worksheets("Sheet2").Range("B5").

Am I alone? any opinions?

Bruno

PS
Well, I know I can't use [Sheet2!B5](2),
[MyRangeVar], etc.
 
Not sure where you get the idea that [] is deprecated.

Sure [A1] is faster to type than Range("A1"). It may be fine for quick
testing but suggest never use it in completed code.

1. the object is hardcoded
2. no intellisense
3. internally *considerably* more work is required to "Evaluate" whatever is
between the square brackets. Qualifying with Range directly gets the
object's properties and methods from the type library.

Regards,
Peter T
 
You did get replies.

I'm not sure how you're looking, but I use google to search groups.

http://groups.google.com/advanced_search?&as_ugroup=microsoft.public.excel.*

Give it enough information (you as the author, maybe a keyword or date) and
you'll find it.

Bruno said:
I posted this on microsoft.public.excel but I didn'n
get any opinions yet.
May be I'll be more this side...
--------------------------------------------------------------
What's about MS "deprecated" notation [Sheet2!B5]?
I'm using that notation as it is much simpler to write
than Worksheets("Sheet2").Range("B5").

Am I alone? any opinions?

Bruno

PS
Well, I know I can't use [Sheet2!B5](2),
[MyRangeVar], etc.
Click to expand...
 
Back
Top