Can I erase a reference name and reuse the reference name for another range?

Can I erase a reference name and reuse the reference name for another range?  It looks like once I use a reference name and mark the range, I can't erase the name and reuse the reference name for another range? it will indicate the name already use on this sheet even I deleted this reference name?


Is there a search function to search for where a "reference name" is used within a sheet?

Best Answer

Answers