#NAME? value

I have been writing some code to replace leading and trailing spaces in cells in a workbook and one of the incoming pieces of data (that I cannot control) has the #NAME? value in the cell.

Needless to say, the code can't remove any spaces from it because its value isn't a string. The problem is I cannot figure out how to write the code to remove those entries because I can't identify it.

What is the "#NAME?" value as VB can identify it?

Please Login or Register  to view this content.

The above does not work, because it isn't a string with the value, so I am trying to find out what the value is and cannot seem to Google it.

Thank you, I knew it was something simple I was overlooking.