ADAdministrator Syncfusion Team January 9, 2005 05:20 PM
No. The style.FormattedText may change, but the style.Text value always has to be the formaula.
The only way that a named range can affect a cell is if the cell is a formula cell (style.CellType = "FormulaCell") and if the style.Text value for that cell holds a formula (string starting with an =).
So, for such a cell, the style.Text value will have to be a formula, and this does not change. What is displayed in teh cell, style.FormattedText, will change as teh result of NamedRange, but the style.Text will not change.