GrapeCity.Documents.Excel.IName.RefersTo

RefersTo Property

RefersTo

Gets or sets the formula that the name is defined to refer to, in the language of the macro and in A1-style notation, beginning with an equal sign.

Use this property to retrieve or set the current A1-style formula, cell reference, range reference, or constant assigned to the defined name.

Declaration

string RefersTo { get; set; }

Property RefersTo As String

Examples

worksheet.Range["A1:A3"].Value = new object[,] { { 100 }, { 200 }, { 300 } };
IName definedName = worksheet.Names.Add("SalesTotal", "=A1:A3");
string formula = definedName.RefersTo;