No,

This will delete all of the names, if you have a static list of the
names that you DONT want deleted then this can be built in........

Duncan


Guru Vikram wrote:

Duncan,
Thanks for your prompt response.
But in this case, I've named some ranges other than this query, which
has linked with the query table (say adjacent cell formulas). I am
affraid, with this code all the names may be deleted.
Can I try these codes?

Guru Vikram


--
Guru Vikram
------------------------------------------------------------------------
Guru Vikram's Profile: http://www.excelforum.com/member.php...o&userid=36404
View this thread: http://www.excelforum.com/showthread...hreadid=564171