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