Hello montroseite,

Your information is incomplete. Without seeing the Validation formula, I can only guess why your are removing the last character. The code sample you posted is a fragment. You should post the full Sub or Function to provide a complete understanding of what you are doing.

Posting your workbook will answer many questions that won't have to be asked. This saves time, and provides a way to test the code before the solution is posted.