I like the idea of always having full error handling, but it's going to put a load on the approvers.

BTW, you need rnTarget As Range