Thanks a million gmayor

It works as expected however it seems to be having issues with months written in French

See the below example with the dates highlighted.

It code is failing at the below highlighted date in the CDate(vSubject(2)) part of the code with a Type MisMatch error.

SLWP Montreal | Care Help Desk Fr. | 27-juin-15 | Shift End: 16:00 | Leave Time: entire day | SLWP (Unpaid)

In contrast if written as

SLWP Montreal | Care Help Desk Fr. | 27-jun-15 | Shift End: 16:00 | Leave Time: entire day | SLWP (Unpaid)

no issues.

Is there anyway around this issue?

Thanks again for your help