Maybe this is obvious to many/most of you, but it took me a little while to figure it out, and I did NOT find any direct examples of this. So, thought I’d share with all . . .
MS Excel Applescript - How to Reference & Use the Active Cell
Note that one key requirement is that the “Active Cell” can be referenced ONLY from the main Excel Application Object – NOT from “Active Workbook” or “Active Sheet”.
tell application "Microsoft Excel" set oActiveCell to active cell -- Returns the currently selected cell tell oActiveCell set value to "TEST Using Tell Cell" set oACFont to font object tell oACFont set bold to true set font size to 18 end tell -- oACFont end tell -- oActiveCell end tell