On the main menu press Insert, then select Name, then select Define. This
will give you a list of all defined names. Go through them and delete the
ones you don't want. This will be quicker than writing a macro of waiting for
a response from here.

Look on it as an education. It will remind you never to make the same
mistake again.

Pip pip

"Mike" wrote:

I have a workbook with about 35 or so tabs. What happened was that on the
first sheet, I named a cell "pe" and then copied that worsheet about 30
times or so. Each worksheet has a different set of data. The problem is
that each worksheet now has a cell named "pe". I only wanted the first
sheet to have a cell named "pe" since I have data being linked to it (cell
=pe, etc.) How can I remove the defined name on each worksheet without
having to manually do it? Maybe there is a macro or something.

Thanks
Mike