Copying data from Excel to PowerPoint as text or table

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.

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