Looping thre named ranges

  • Thread starter Thread starter Jim in Fort Worth Texas
  • Start date Start date
J

Jim in Fort Worth Texas

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

Thank you
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform question 3
loop help 6
How to hide password? 1
Range Defined names loop 5
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Loop Problem 2
Directory Name - IF Named Range Exists 0
Why Range name not showing in list 1

Back
Top