Hi Robert,

Am Thu, 2 Apr 2015 01:18:39 -0700 schrieb Robert Crandal:

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

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

your sText is typ variant and not string


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