Thread: Deleting Names in a Workbook
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Deleting Names in a Workbook
try this,- delete all names

Sub DelNames()
Dim x
For Each x In ActiveWorkbook.Names
ActiveWorkbook.Names(x.Name).Delete
Next
End Sub

Reply With QuoteReply With Quote