This has to be an easy one!!

Real new to this scripting - In fact forced into learning scripting when Excel dropped macros - seems like it should be easy but…

why does this return the correct result →

tell application "Microsoft Excel"
	
	get address of selection

end tell

and this returns “missing vale” —>

tell application "Microsoft Excel"
	
	set MyLocaton to address of selection
	
end tell

Hi,

get something is actually the proper syntax to fetch a value.
In many cases AppleScript adds silently the get command, but not in this one


tell application "Microsoft Excel"
	set MyLocaton to (get address of selection)
end tell

Many Thanks for the fast response.