Using vb.net how does one loop thur named ranges in an Excel Wordbook? Thank you
J Jim in Fort Worth Texas Feb 18, 2010 #1 Using vb.net how does one loop thur named ranges in an Excel Wordbook? Thank you
J joel Feb 18, 2010 #2 this code works in VBA, not sure about VB.Net. For Each nm In ThisWorkbook.Names MsgBox (nm.Name & " refersto : " & nm.RefersTo) Next nm
this code works in VBA, not sure about VB.Net. For Each nm In ThisWorkbook.Names MsgBox (nm.Name & " refersto : " & nm.RefersTo) Next nm
J Jacob Skaria Feb 19, 2010 #3 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
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
