Thanks for the quick reply and this does work as a work around

Do you know why this is happening, is it a known bug with Excel?