Delete name range from selected cells

[Reefer]

Hi guys,

Hoping someone out there can help me. Think it will be pretty easy but here goes.

Trying to write a macro that will choose a selected range (E2:T200) on a secific worksheet (Edit) and delete the name range for that range without touching the rest of the workbook.

Any help will be muchly appreciated.

 

[GopalaKrishnaJ]

Try this

Sub testRemove()
    
    Dim nmWks   As Name
    
    For Each nmWks In ThisWorkbook.Names
        If nmWks.RefersTo = "=Edit!$E$2:$T$200" Then nmWks.Delete
    Next
    
End Sub

 

[Reefer]

Hey Gopala,

I cant seem to get this to work. As i see it, it gets the range but does not delete the name range. Any other ideas?

Reefer