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

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