Activecell.offset(0,5).value = Format(Now,"dd mmm yyyy hh:mm:ss")

--
HTH

Bob Phillips

"bhofsetz" wrote in
message ...

Use

Activecell.offset(0,5).value = Now

HTH


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile:
http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=385675