View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Remove Defined Names

Hi Henrik,

Use the Name Manager written by Jan Karel Pieterse.
You can download it he

http://www.jkp-ads.com/Download.htm

Or use this code from Bob Phillips:

For Each nme In ActiveWorkbook.Names

nme.Delete

Next nme


--
Kind regards,

Niek Otten

"Henrik" wrote in message
...
Hi,

Does anyone know of a VB command that removes all defined names in a
workbook?

In advance, thank you very much for your help.

Warm regards,
Henrik