| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
C# .net and Excel Named Ranges
Try Range TheRange TheRange = Workbook.Names("Calcs").RefersToRange This assumes that the name "Calcs" refers to a range. It is possible to have a Name that refers to a constant or formula rather than a range. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Tue, 9 Dec 2008 07:20:17 -0800, Jorge Ribeiro wrote: Hello I've a named range "Calcs". I want to get an Excel.Range object that reference that particular named range. I could do this iterating workbook.names collection but it seems to me that there must be another way to accomplish this. Can you help me here? Best regards Jorge |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named ranges and pasting formulas with named references | Excel Programming | |||
| VBS for excel named ranges | Excel Programming | |||
| Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
| Copy data in named ranges to a newer version of the same template to identical ranges | Excel Programming | |||
| VB.Net DLL Using Excel Named Ranges | Excel Programming | |||
Hybrid Mode
