Many thanks Whizbang I knew about the REF solution but was looking for something like this as many range names get mixed when working with different workbooks