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
|