On Tuesday, October 7, 2014 11:39:33 AM UTC-7, GS wrote:
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



Info noted, thanks.

Howard