We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

NamedRange

How do I set the value programtically for a named range? Thanks

3 Replies

Administrator December 1, 2004 11:29 AM UTC

If it is a new namedrange that has not been registered yet, you would use code like: GridFormulaEngine engine = ((GridFormulaCellModel)gridCashFlow.Model.CellModels["FormulaCell"]).Engine; //name is the NamedRange name //val is the NamedRange value engine.AddNamedRange(name, val); If the name is already present in the NamedRanges, you can change its value using engine.NamedRanges[name] = val;

SA Saravanan replied to Administrator March 21, 2018 03:45 PM UTC

If it is a new namedrange that has not been registered yet, you would use code like: GridFormulaEngine engine = ((GridFormulaCellModel)gridCashFlow.Model.CellModels["FormulaCell"]).Engine; //name is the NamedRange name //val is the NamedRange value engine.AddNamedRange(name, val); If the name is already present in the NamedRanges, you can change its value using engine.NamedRanges[name] = val;

Test

Sindhu Nagarajan March 22, 2018 05:27 AM UTC

Hi Saravanan, 
  
Thanks for the update. 
  
We will wait till we hear from you. Please let us know if you need further assistance. 
  
Regards,  
Sindhu 

Loader.
Live Chat Icon For mobile
Up arrow icon