| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Looping thre named ranges
Using vb.net how does one loop thur named ranges in an Excel Wordbook?
Thank you |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| looping thru named ranges | Excel Programming | |||
| Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
| Looping through named ranges | Excel Programming | |||
| Deleting named ranges by looping through range collection | Excel Programming | |||
| Looping through named ranges | Excel Programming | |||
Linear Mode
