Hi Garry,

Am Thu, 02 Apr 2015 10:32:28 -0400 schrieb GS:

However, I would leave the arg type as
string because the function manipulates strings by design AND name, to
return a string. Mixing data types is going to cause confusion at some
point, and so should be avoided (IMO)!

then he could put in vData by Value instead of reference:

Function TruncateString$(ByVal sText$, sFind$, Optional lStart& = 1)


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional