Try this as an example discussion.https://www.ablebits.com/office-addi...c-named-range/. There is a downloadable workbook at the end for you to use in conjunction with the explanation.