Thread: Removing Names
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Removing Names

On the menu bar...InsertNameDefine... Then select the names you want to
delete and click delete.

"ranswrt" wrote:

I made the mistake of writing a procedure that deleted selected sheets in my
workbook. I deleted the sheets without deleting the name cells in that
sheet. Now when I use 'F3' to paste the list of named cells I have about 800
names that don't exist in my workbook. How can I remove these?
Thanks