Code won't work when sheetname is changed

Originally Posted by Norie

Can you upload a sample workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

Here's my worksheet, the SF1 sheet works as it is the original but once I make a copy "SF1 (1)" sheet, error happens.

ECR.xlsm