EnergyPlus IDF editor copy paste

Is there a 'trick' or means to copy/paste from the IDF editor? I'm thinking of the eQuest 'trick' where one must use ctrl+shift and copy/paste works again; and wondered if anyone had anything that worked same/similar in IDF world. This is highly useful fro moving to/from MS excel. Thanks.

IDF to Excel

Excel to IDF

Usage

For the other way around, I wrote a macro that will read in an excel table and export that to an IDF compatible object so that you can paste it in the IDF editor or in your .idf text file itself.

I've personally added this macro to an Excel Add-In and added a button on a separate tab for easy access:

To use the macro, place your cursor in any of the cells of the table and launch it. It will try to find the EPlus class name in the cell that's 2 rows above the top-left corner of the table to prepopulate a dialog box asking you for the class name: either it's good and click OK, or it isn't or it didn't find it, type the name of the class.
It'll then generate proper IDF objects that you can paste in IDF editor or paste directly in the .idf file. It'll ask you whether you want to save it as a file (and subsequently ask for a file name) or copy it to clipboard.

Firstly, thank you for this macro, it's a godsend. Secondly, when I try to run it, i get an error "user defined type not defined" in regards to "Dim MyDataObj As New DataObject". Any way I can solve this? I'm fairly inexperienced in VBA and dying to use this macro.
Thanks in advance.

As stated in the comments atop the macro: ' References: Microsoft Forms Object 2.0, needed for using the Clipboard. Enable this. Or just go to my Github and download the addin (xlam) and more and start using it right away (this is by far what I recommend doing especially if you're not experienced in VBA. And you'll get the possibility of using the add-in on any workbook, even those without integrated macros (xlsx, not xlsm). The readme should be detailed enough