You're welcome. Glad it helped.

Jerry

Mark Goodwin wrote:

Thanks Jerry, that formula works a treat.

Now I just have to apply it to the other 350 other workbooks!

Regards
Mark