Create a worksheet change event from an addin macro

A report I have just inherited contains much data that needs to be copied and pasted into another programme. The report is exported from yet another system so is bare xlsx format. I have created an addin where I can run a column delete from the QAT.
I am trying to implement this code to be able to copy by select and paste into the other programme. This would need to reside in the worksheets module. Is there a way to declare the range from outside the worksheet module or alternatively a way to copy the code into the worksheet module.

Please Login or Register  to view this content.

ultimately I would like the target row to be deleted from the worksheet once pasted.

Help appreciated

found code from davesexcel which needs not to add a new worksheet. Although the Worksheet name is seen in the debugger it errors on line shown. It will complete if adding a new worksheet.

Please Login or Register  to view this content.