Many thanks Dave and cheers for the link. Will be using macros in my workbook so will stick with option 1