Mac Forum / Applications / Excel / September 2007

I am trying to create a very simple macro.

(1) enter current time i.e. @now()
(2) copy this time and paste special as value (to fix the current time
as a time stamp)

Every time I create the macro and run it, it creates the @now() time
value BUT does not fix it as a value.

The following is the generated code:

   ActiveCell.FormulaR1C1 = "=NOW()"
   Range("D32").Select
   Selection.Copy
   Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone,
SkipBlanks:= _
       False, Transpose:=False
   Range("E32").Select
End Sub