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
