View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Looping thre named ranges

As Joel mentioned the names is a collection which is part of the XL object
model.

xlApp.ActiveWorkbook.Names.Count

PS; An object type is available for Excel names
Microsoft.Office.Interop.Excel.Name

--
Jacob


"Jim in Fort Worth Texas" wrote:

Using vb.net how does one loop thur named ranges in an Excel Wordbook?

Thank you