problem with the macro after moving to another workbook

If it works fine in the other workbook then it's almost certain that the workbook/ worksheet is explicitly referenced (meaning it points exactly to the file e.g. "ThisWorkbook.xlsm" so when you run in ThisWorkbook.xlsm it's fine. However when you copy that code or rename the workbook/ worksheet it will have pieces of code that refer to ThisWorkbook.xlsm and it will fail at that point.

Try hitting Ctrl & F (Find menu) and do a search for your worksheet name (the one where it did work). Replace it with the name of your new workbook. If you replace all references of these it should be fine.

no this is not it

run time error '13': type mismatch