Exclamation Copy - Paste entire table into one cell using active cell formula

[alexgoaga]

Hello.

I have a problem with the VBA using the copy paste formula to copy the entire content of the table into one single cell (as an active formula)

I've attached a simple table for a demo.

I've noticed that even as normal user you cannot simple copy - paste a table then double clicking into one active cell formula and paste it, the trick would be to Enable the Clipboard with clicking anchor in the bottom-right corner of Clipboard group on the Home tab.

Here (

https://www.extendoffice.com/documents/excel/2919-excel-paste-into-one-cell.html

) would be a tutorial for a user - friendly mode, but i can't do it in VBA. Any ideas or tricks?

Thanks .

P.S this question was posted also on :

https://www.excelforum.com/excel-programming-vba-macros/1188474-copy-paste-entire-table-into-one-cell-using-active-cell-formula.html

, but still not answered