delete named ranges

I have 50 named ranges. Some of them are just a range, others have dynamic ranges (formulas). None appear to be incorrect. Everything is calculating correctly based off of the named ranges. I have used the Name Manager to filter for Names with Errors and there are none listed. I need to...

I am trying to remove all named ranges/defined names in my workbook. I was pretty sure that it would be simple. I am using the following code: Sub DeleteNames() Dim xn As Name For Each xn In Application.ActiveWorkbook.Names xn.Delete Next End Sub However, I get an error message: I...

Hi All, I just replied to a previous post, but in hindsight, should have started a new topic. I have a list of Names that are Named Ranges. Is it possible to use the list to batch delete the Named ranges instead of looping through each one? Thanks, Keith

I have workbook with multiple tabs on a worksheet. when I click the name manager nothing happens. How can I view all the names in the workbook and delete the selected names. I try using the macro blow but no luck. Sub DelRefNames() Dim n As Name For Each n In ActiveWorkbook.Names If...

Hello I have been writing a code to select all the sheets in my workbook and then delete the cells in which data has to be input to create a new blank template every time to reuse. I named the range in which data can be input as "NeedDel" whose scope is restricted to the sheet itself. The...