2 worksheet open, one is macro coding and the other one is being coded.

How do I code date and time on another sheet. Alternative to code below.
Range("A2").Select
ActiveCell.FormulaR1C1 = "=NOW()"