That works brilliantly thank you, but unfortunately I do have a few other named ranges throughout the workbook. Is it possible to apply this macro to the active sheet only?