You could dynamically change the value of the RefersToRange Property of the Name object.
Declan Don't forget to mark your Thread as resolved. Take a moment to rate posts that you think are helpful
Forum Rules
Reply With Quote