Category / Section
How to update WinForms TabbedMDIManager?
1 min read
Named ranges collection belong to the workbook and not to the worksheet. If you define two Named ranges with the same name, then the named range that was defined last will replace the previous named range.
C#
//Defining a Range IName lname = sheet.Names.Add("Products"); lname.RefersToRange = sheet.Range["A1:A6"]; //Defining the Range and using it in the Formula IName lname1 = sheet.Names.Add("One"); lname1.RefersToRange = sheet.Range["C3"]; IName lname2 = sheet.Names.Add("Two"); lname2.RefersToRange = sheet.Range["D3"]; // Formula using Defined Names sheet.Range["E3"].Formula = "=SUM(One,Two)";
VB
Dim lname As IName = sheet.Names.Add("Products") lname.RefersToRange = sheet.Range("A1:A6") Dim lname1 As IName = sheet.Names.Add("One") lname1.RefersToRange = sheet.Range("C3") Dim lname2 As IName = sheet.Names.Add("Two") lname2.RefersToRange = sheet.Range("D3") sheet.Range("E3").Formula = "=SUM(One,Two)"
Here is the sample for your reference:
https://www.syncfusion.com/downloads/support/directtrac/89898/NamedRanges421999033.zip