Deprecated [...]

Bruno Campanini · External Since: Jun 01, 2007 Posts: 7

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.

Bernard Liengme · External Since: Aug 27, 2003 Posts: 146

Not sure of your question
This worked in XL2007 as well as XL2003

Sub tryme()
Range("J5") = [Sheet3!A1]
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bruno Campanini" <BC.DeleteThis@gmail.com> wrote in message
news:uFjf5bJXKHA.844@TK2MSFTNGP05.phx.gbl...
> 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.
>

Bruno Campanini · External Since: Jun 01, 2007 Posts: 7

"Bernard Liengme" <bliengme RemoveThis @stfx.ca> wrote in message
news:#iD9kkJXKHA.3696@TK2MSFTNGP02.phx.gbl...

> Not sure of your question
> This worked in XL2007 as well as XL2003
>
> Sub tryme()
> Range("J5") = [Sheet3!A1]
> End Sub

No.
I said I'm using [Sheet3!A1] instead of
Worksheets("Sheet1").Range("A1")

Then:

Set MyRange = [Sheet3!A1]
instead of
Set MyRange = Worksheets("Sheet1").Range("A1")
and so on.

I know MS states [Sheet3!A1] is "deprecated"
compared with Worksheets("Sheet1").Range("A1").
I'wondering how many people act this way and what
pros and contras.

Bruno

Bernard Liengme · External Since: Aug 27, 2003 Posts: 146

Sorry I am confused
Sheet3 is the same as "Sheet1" ???

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Bruno Campanini" <BC DeleteThis @gmail.com> wrote in message
news:eQEc83JXKHA.844@TK2MSFTNGP05.phx.gbl...
> "Bernard Liengme" <bliengme DeleteThis @stfx.ca> wrote in message
> news:#iD9kkJXKHA.3696@TK2MSFTNGP02.phx.gbl...
>
>> Not sure of your question
>> This worked in XL2007 as well as XL2003
>>
>> Sub tryme()
>> Range("J5") = [Sheet3!A1]
>> End Sub
>
> No.
> I said I'm using [Sheet3!A1] instead of
> Worksheets("Sheet1").Range("A1")
>
> Then:
>
> Set MyRange = [Sheet3!A1]
> instead of
> Set MyRange = Worksheets("Sheet1").Range("A1")
> and so on.
>
> I know MS states [Sheet3!A1] is "deprecated"
> compared with Worksheets("Sheet1").Range("A1").
> I'wondering how many people act this way and what
> pros and contras.
>
> Bruno
>
>
>
>
>

Bruno Campanini · External Since: Jun 01, 2007 Posts: 7

"Bernard Liengme" <bliengme.RemoveThis@stfx.ca> wrote in message
news:um71S#JXKHA.3428@TK2MSFTNGP06.phx.gbl...
> Sorry I am confused
> Sheet3 is the same as "Sheet1" ???

Yes of course, my typo!

Bruno

Charles Williams · External Since: Apr 14, 2004 Posts: 96

I have not heard anywhere that the [] notation is deprecated.

Its shorthand for the Application.Evaluate method.

Advantages are that its shorter.

Disadvantages are
- you cant use a string so the reference is hard-coded into your code
- its slower
- its Application.Evaluate rather than Worksheet.Evaluate
- ...

I mostly only use Evaluate with Defined Names

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Bruno Campanini" <BC.DeleteThis@gmail.com> wrote in message
news:uFjf5bJXKHA.844@TK2MSFTNGP05.phx.gbl...
> 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.
>
>