Remove All Defined Names

[allisonmetzger]

This macro was extremely helpful. However for some of the workbooks that I am trying to apply, I am getting a debug error on n.delete. Any ideas? Thanks!!

http://www.excelforum.com/excel-prog...ned-names.html

[mdbct]

It would be helpful if you supplied a little more information. At the very least,what was the error that you received?

The macro runs fine on my end on workbooks with and without defined names.

[Leith Ross]

Hello allisonmetzger,

Welcome to the Forum!

Did you use the code with "ActiveWorkbook" or "ThisWorkbook"? The error is probably occurring because either the workbook name is incorrect or the name doesn't exist. For best results, you should post your workbook for review.

Sincerely,
Leith Ross