Thanks Vasant.

I think what you have provided is what I want. In essence, what
wanted was that these superfluous range names no longer appear in th
names list box at the top left corner of the workbook window.
certainly didn't want the range or the contents of the range deleted.

So, thanks again for correctly guessing what I wanted and the
providing the solution too.

Best regards


Deepa

--
Message posted from http://www.ExcelForum.com