Diane,

You may do that as follow:


Application.Goto Reference:="R12C1"
ActiveCell.FormulaR1C1 = "=NOW()"

line 1 will bring you to the desired cell (in this example A12)
Line 2 fills the datestamp in mentioned cell.
You may use a variable for the cell reference so you can use the same
routine and only need to change the variable on forehand.
Please make sure the target cells for the datestams are formated
properly. (dd-mm-yy HH:MM:SS) or whatever you want. General format may
do the job also.

Regards,

Ronald.


nova.planet.nl wrote:
Diane Alsing wrote:

I have a macro written and I would like to have it put a datestamp in
a cell after running. Basically I would like it to fill a cell with
today's date as the last line of code so I can keep track of when it
was last run successfully. I tried the following, but it does not
seem to work.

Range("F5") = Now

Any help would be greatly appreciated.
Regards, diane