I tested it. But it is only working with VBA. For the function MID
into
the worksheet the third argument (length) is a must

I was referring to its use in your code, and your comment to Howard
about changing its value 99. I understood you to be using it same as
is required in Worksheet.Function and thought it helpful to know that
the VB[A] works differently.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion