From your reply to Peo in the other branch
... still getting a syntax error ..

Think you were hit by the dreaded "inevitable" line breaks / wraps
when you copy pasted Bob's UDF (appear as red lines in VBE).
These breaks ave been corrected in the sample implementation.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--