You didn't say how to reproduce the issue, but just making a Delete on the Referals sheet I got the error

Some where in your code you're getting a Target with multiple cells and Trim doesn't work


Capture.JPG