Worksheet change event copy column error

Originally Posted by Keebellah

The problem is that you're switching sheets and that is not allowed with events, you have to approach it differently. Not inside a worksheet module

Thanks i fixed it

Dim wb As Workbook
    Set wb = Application.Workbooks("worksheet1.xlsm")
    wb.Activate
    'wb.Sheets("Sheet1").Range("A1").Select  'No error.