Add Method

Defines a new name. Returns an IName interface.

Defines a new name. Returns an IName interface.

[Visual Basic] Function Add(ByVal String,ByVal IRange) As IName

[C#] IName Add(string,IRange);

[C++] IName* Add(String*,IRange*);

[JScript] function Add(String,IRange): IName;

Defines a new name. Returns an IName interface.

[Visual Basic] Function Add(ByVal String,ByVal IRange,ByVal Boolean) As IName

[C#] IName Add(string,IRange,bool);

[C++] IName* Add(String*,IRange*,bool);

[JScript] function Add(String,IRange,bool): IName;

Defines a new name. Returns an IName interface.

[Visual Basic] Function Add(ByVal String,ByVal String) As IName

[C#] IName Add(string,string);

[C++] IName* Add(String*,String*);

[JScript] function Add(String,String): IName;

Defines a new name. Returns an IName interface.

[Visual Basic] Function Add(ByVal String,ByVal String,ByVal Boolean) As IName

[C#] IName Add(string,string,bool);

[C++] IName* Add(String*,String*,bool);

[JScript] function Add(String,String,bool): IName;

This example adds new defined name for the workbook and use this name in the cell formula.

[C#]
Workbook.Names.Add("MyName","=Sheet1!$F$10:$H$20");
Workbook.Worksheets[1].Cells[3,4].Formula = "=SUM(MyName)";

[Visual Basic]
Workbook.Names.Add("MyName","=Sheet1!$F$10:$H$20")
Workbook.Worksheets(1).Cells(3,4).Formula = "=SUM(MyName)"

[C++]
Workbook->Names->Add(S"MyName", S"=Sheet1!$F$10:$H$20");
Workbook->Worksheets->Item[1]->Cells->Item[3,4]->Formula = S"=SUM(MyName)";

INames.Add Method