previously mbizup helped me out with deriving this code. but after i run it and it successfully deletes all the named ranges, it still pops up with the invalid reference error message. i'm really not sure how to suppress this error message. could yall help me? thanks!!
On Error Resume NextApplication.DisplayAlerts = FalseDim nr As Name For Each nr In ActiveWorkbook.Names Debug.Print nr.Name nr.Delete NextExit Sub