Hi J.E.
my mistake, thanks for nthe correction!

--
Regards
Frank Kabel
Frankfurt, Germany

JE McGimpsey wrote:
Why would it throw an error?

The parens are unnecessary, but otherwise it should work with the VBA
Now function.


In article ,
"Frank Kabel" wrote:

this line
Sheets("Sheet1").Range("A1").FormulaR1C1 = Now()

should throw an error. You probably meant:
Sheets("Sheet1").Range("A1").FormulaR1C1 = "=Now()"
though this will update the value with each re-calculation