Why is there a type mismatch error in excel?

Question

Visual Basic

The script worked flawlessly for a long time. At some point there was a failure. At the moment of failure, the script issues an error notification and allows you to open the program for debugging in microsoft vizual basic, where the part of the script where the program stops is highlighted in color. Please tell me how to fix.