Sorry for the inconvenience and please ignore this post - have just found out that this needs to happen in Access and not Excel. Will post in the Access forum.

Thanks and have a fab day.