Excel automation

[Christer Claesson]

Hello there. I was wondering if anyone know if there exist a way to iterate through your named ranges? All I seem to find is: (Excel.Range)App.get_Range("test", Type.Missing); Where "test" would be a named range I've specified before manually. I would love to find some easy method like :foreach(NamedRange in ..) etc. So it iterates through all my previously defined names, for example test, test1, test2 etc. I'm also having large troubles actually getting the name "test" out of anything. rng.Name only gives the address to the range. I would like this because I want to iterate through all named ranges, sending the name of the range to a webservice and depending on what I would get back I would set a value. Right now I will need to code every specifik instance of them and that will make it harder to add things. Thanks Christer.