By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

Activesheet.Names(sName).Delete ' deletes a named range

This statement allows you to delete a range name on the activesheet.

You can use the Macro recorder to discover how to manage named ranges.

Exercise

Write a routine that can find bad named ranges and remove them