Docs HotXLS

RefersTo-property

Renvoie or sets the Formula that the name is defined to refer to, in A1-style notation, beginning with an equal sign. Read/write WideString

Syntaxe

property RefersTo: WideString;

Exemple

This example changes the Formula for 'MyName' defined name of the Workbook

With Workbook.Names do begin
   if Assigned(Item['MyName']) then
      Item['MyName'].RefersTo := '=Sheet1!$A$1';
end;

Voir aussi

IXLSName Interface
IXLSName.RefersToRange propriété
IXLSNames Interface
IXLSWorkbook.Names propriété
TXLSWorksheet.Names propriété