RunTime Error 9 -Copying Worksheet to Exisiting Macro with same worksheet name

[jaspalsd]

Hi,

I have tried the following which does work when run in another module but when I put it at the beginning of my main macro (which worked previously) it will bring an error.

Further on down I have a macro relating to the newly created worksheet and I also amended it to include ThisWorkbook ahead of it but this didn't make a difference

Sub OPL()

    Windows("Asset Management Maturity.csv").Activate ' the emailed file
    Sheets("Asset Management Maturity").Copy After:=ThisWorkbook.Sheets("Cleanup")   
    

.........

I could try an alternative and just copy/paste the contents of the range in the other workbook using the same worksheet name but it will be helpful to know how to fix it if I want to copy the worksheet as a whole

Thanks

 

[jaspalsd]

fixed it

had to include the workbook name in front!