Copying data from Excel to PowerPoint as text or table

[BillDoor]

hi all

I have the below code for copying and pasting ranges from Excel into PowerPoint that works perfectly fine, however, I would like to change the second range to be pasted as a text box or table (keeping the formatting from excel), so that the text within that could be edited within PowerPoint afterwards if required
I think the part where it deletes shapes will also need amending, I've tried but keep getting errors, can anyone please help?

thanks

Please Login or Register  to view this content.

[BillDoor]

sorry to bump, but does anyone have any ideas for how to do this, or another way please?
thanks