The Core Add-in includes this shortcut menu item that adds a Write to Worksheet command for the current cell location with the option to preserve formatting.
Select the worksheet and cell, then choose the menu item to Write to Current Cell. A new Write to Worksheet command will be added to the macro to write the active table in memory to the specified location. You can edit the Write to Worksheet command to change the options if desired.