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