Need help interpreting a code line
 

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

Need help interpreting a code line
 

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".

Need help interpreting a code line
 

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