STRANGE problem when passing an email address to function

Welcome to the Forum Matt7272 !

There is no way to answer this without seeing the code you are using and how you are using it. Attach a file with the code and at least example you are describing with both the cell with an email address and how you are calling the function.

The problem is in the function TrueTrim. It modifies the input argument, which is a poor coding practice for a function. In VBA, the default argument mode is ByRef, so the modified argument is updated in the caller. The function should really use a local variable to do this, but the easiest fix is to explicitly use ByVal.

Public Function TrueTrim(ByVal str1 As Variant) As String

Dim i As Integer

' Problem is here
str1 = WorksheetFunction.Trim(Replace(str1, Chr(160), Chr(32))) 'per far funzionare Trim in modo corretto eliminando tutti i tipo di "spazi"

I didn't remove it, I added it. ByRef is the default, so I added ByVal.

ByRef means that when the argument is referenced in the function code, it is by address. Any changes made to that argument affect the the value of the variable that was passed by the caller.

ByVal means that a copy of the argument is made to be available locally by the function code. Any changes to that argument are local to the function, and do not affect the caller.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.