Hello, why doesn't anyone use the [A1] notation? It seems easier to
write
[A1].select
than
Range("A1").select

so why do I never see it used, I'm guessing there must be a reason...

Thanks

Michael

I (almost) always use that

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Michael" wrote in message
...
Hello, why doesn't anyone use the [A1] notation? It seems easier to
write
[A1].select
than
Range("A1").select

so why do I never see it used, I'm guessing there must be a reason...

Thanks

Michael

They probably learned it from the macro recorder.

Plus, you lose intellisense.

--JP

On Oct 15, 6:42*am, Michael wrote:
Hello, why doesn't anyone use the [A1] notation? It seems easier to
write
[A1].select
than
Range("A1").select

so why do I never see it used, I'm guessing there must be a reason...

Thanks

Michael

Hi Michael,

Hello, why doesn't anyone use the [A1] notation? It seems easier to
write
[A1].select
than
Range("A1").select

One reason might be that the piece between brackets has to be interpreted
(evaluated) by the compiler before it can be "used". So it is slower.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

1. Fully "qualifying" rather than "evaluating" saves a lot of work behind
the scenes, ie faster.

2. With Range(sAddress) no need to hardcode

3. You get all the intellisense after typing Range("a1") dot

In the following Range() vs [A1] loops 2.5 x faster for me -

Sub test()
Dim t As Single, i As Long, d As Double
[A1] = 123

For k = 1 To 3
t = Timer
For i = 1 To 100000
If k = 1 Then
x = [A1].Value
ElseIf k = 2 Then
x = [=A1]
Else
x = Range("A1").Value
End If
Next
Debug.Print Timer - t
Next

End Sub

For quickly trying things out I use [A1], but never in completed code.

Regards,
Peter T

"Michael" wrote in message
...
Hello, why doesn't anyone use the [A1] notation? It seems easier to
write
[A1].select
than
Range("A1").select

so why do I never see it used, I'm guessing there must be a reason...

Thanks

Michael