Tested with Microsoft Excel 16.16.27 from Office 2016.
Hey Anthony,
Microsoft Excel has a private clipboard that does not play nice with the system clipboard.
To make Excel's clipboard sync with the System, you have to switch out of Excel and then back again. It's clunky, but it works.
Here's an example for pasting into the Excel VBA Editor:
Microsoft Excel ⇢ Insert String into Visual Basic Editor v1.00.kmmacros
You can use a similar technique to copy from it.
You can use Keyboard Maestro native actions for switching instead of the shell:
ACTIONS ARE DIRECTLY IMPORTED INTO THE MACRO BEING EDITIED!
Keyboard Maestro Actions.kmactions (1.3 KB)
Typinator works in the VBA editor just fine, although it beeps at you when inserting a string.
-Chris