D
Dag Johansen
Hi,
ActiveCell.Value = "5"
will give the cell text content equal to "5".
ActiveCell.Formula = "=5"
gives a *formula*.
Although assigning "=5" to the Value property may achieve
the same result, for the sake of readable code you should
assign the Formula property rather than the Value (since a
cell's value is either text content or *the evaluation* of
the formula).
Happy coding!
Dag -- DagOystein.Johansen AT sage.fr
ActiveCell.Value = "5"
will give the cell text content equal to "5".
ActiveCell.Formula = "=5"
gives a *formula*.
Although assigning "=5" to the Value property may achieve
the same result, for the sake of readable code you should
assign the Formula property rather than the Value (since a
cell's value is either text content or *the evaluation* of
the formula).
Happy coding!
Dag -- DagOystein.Johansen AT sage.fr