Thread: Named range prob using VB to move wksheet to an existing wkbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
green biro green biro is offline
external usenet poster
  
Posts: 6
Default Named range prob using VB to move wksheet to an existing wkbook


Is there a way to delete all named ranges in a workbook?

Sub blahblaah()

With ActiveWorkbook

For x = .Names.Count To 1 Step -1

.Names(x).Delete

Next

End With

End Sub



Regards



GB


Reply With QuoteReply With Quote