Set filepath = [KML_Details !C2]

I know KML_Details is the sheet name and C2 in the cell but I don't know
what the brackets [ ] are there for. Can someone explain to me why it is
written this way and not

Set filepath = Worksheet("KML_Details").Range("C2")

Any help will be greatly appreciated.
Thanks

Ayo wrote:
Set filepath = [KML_Details !C2]

I know KML_Details is the sheet name and C2 in the cell but I don't know
what the brackets [ ] are there for. Can someone explain to me why it is
written this way and not

Set filepath = Worksheet("KML_Details").Range("C2")

Any help will be greatly appreciated.
Thanks

It is a shortcut for the Evaluate method.

[KML_Details!C2] == Evaluate("KML_Details!C2")

I'm not so smart though. I just ran across that syntax last night,
actually. See F1 on "Evaluate".

squaer braces is an "old fashioned" way of addressing cells and should be
avoided as much as possible.



"Ayo" wrote:


Set filepath = [KML_Details !C2]

I know KML_Details is the sheet name and C2 in the cell but I don't know
what the brackets [ ] are there for. Can someone explain to me why it is
written this way and not

Set filepath = Worksheet("KML_Details").Range("C2")

Any help will be greatly appreciated.
Thanks