How to delete a single named range from a worksheet

[sspatriots]

Hi,

This seems like a silly question, but nothing I've tried seems to work. I have a worksheet called "Jobs" and on that worksheet there is a named range called "HYDROJNRange". I've placed the line of code below in my macro to get rid of it, but I keep getting a Runtime Error 1004 "Application-defined or Object-defined error". Any help on what I am missing here would be greatly appreciated.


Thanks, SS

    ActiveWorkbook.Names("HYDROJNRange").Delete

 

[sspatriots]

Ok, I think I found the trick to creating it with the Workbook Scope. Changed the last bit of code that created the named range to the following and it worked.

Sub HYDROJNRange()

    Dim iName As String
    iName = "HYDROJNRange"
'    ActiveSheet.Names.Add Name:=iName, RefersTo:=Selection
    ActiveWorkbook.Names.Add Name:=iName, RefersTo:=Selection
    
End Sub

Thanks for all the help and clearing this up for me.