Looping thre named ranges
 

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

Thank you

Looping thre named ranges
 

this code works in VBA, not sure about VB.Net.


For Each nm In ThisWorkbook.Names
MsgBox (nm.Name & " refersto : " & nm.RefersTo)
Next nm


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180631

Microsoft Office Help

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