If the recorder produces......why then would the following fail with the goal being to remove all named ranges from a selection?![]()
ActiveWorkbook.Names("MyName").Delete
I'm receiving an 'Application or Object Defined Error' at line![]()
Sub DeleteNamedRange() Dim rngCell As Range For Each rngCell In Selection ActiveWorkbook.Names(CStr(rngCell.Name)).Delete Next rngCell End Sub
![]()
ActiveWorkbook.Names(CStr(rngCell.Name)).Delete
Bookmarks