Disable PowerPoint Auto-Resizing Pasted Ranges

[XLjedi]

In VBA (or manually) when I copy a range from Excel and paste it into
PowerPoint the table that is created in PowerPoint is resized (made smaller)
than the original range. The resulting table is exactly 2/3 it's original
size. This is NOT a handy feature as I am perfectly capable of resizing
table objects if needed.

I need to maintain the original size of the range and the font size. How do
I disable or workaround this "helpful" feature.

 

[XLjedi]

Thankfully I managed to stumble upon the ScaleProportionally method.

I was able to manage the following workaround to my problem...

If PPShape.Height <> Objt.Height Then
PPShape.Table.ScaleProportionally Objt.Height / PPShape.Height
End If

So after pasting the range from Excel (Objt) into PowerPoint (PPShape) I
test the shape to see if the pixel height is different and the
Table.ScaleProportionally method allows me to undo any resizing that
automagically happened.