Excel application works on concept of cell which is nothing but intersection of row and column. However a single cell is called as a range which is a most important member of excel object hierarchy. Various formulae in excel application will work on the ranges to get final result. Ranges can be named to a object know as Named Range which will be further used in macro code to perform certain data manipulation.

Sometime, we need to delete specific named range in the workbook which will not be used furthermore. Delete specific named range will be quite time consuming when there are large number named ranges created in the workbook. We can simply automate this task by adding few line of code in macro.

Here is the code which will delete specific named range from the workbook:

Sub Delete_Named_Ranges()
' Author: Dreams24
' Written for VBA Tricks and tips blog
' https://www.vbatricksntips.com

' Declare variable
Dim nRng As Name
Dim rName As String

rName = "Test_Range"

' Loop through all Name ranges in workbook
    For Each nRng In Names
        If nRng.Name = rName Then
            MsgBox "Name Range: " & rName & vbNewLine & "    deleted successfully", vbInformation
        End If
    Next nRng

End Sub

Share this post if you think this is really useful...