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

dont know of a VB.
but you can remove them by going into
insert/name/define/select the name and delete it..


--
Joe@excel
------------------------------------------------------------------------
Joe@excel's Profile: http://www.excelforum.com/member.php...o&userid=29016
View this thread: http://www.excelforum.com/showthread...hreadid=487538

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