NamedRanges

Is it possible to set the text value of a cell using the namedrange. Thx

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.