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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 812 - 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