I have tried writing a macro that would let me capture the date from my
computer and place it in cell D2. The captured day will be moved intact at
the end of the day

Is there a command that will let me do that?

Thanks for the help in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200609/1

Hi,

Why do you need a macro for this if Excel has a formula like this? In Cell
D2, put: =TODAY()

"Larry Fish via OfficeKB.com" wrote:

I have tried writing a macro that would let me capture the date from my
computer and place it in cell D2. The captured day will be moved intact at
the end of the day

Is there a command that will let me do that?

Thanks for the help in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200609/1

Sub Macro1()
Sheet1.Range("D2") = Date
End Sub
Regards,
Alan.
"Larry Fish via OfficeKB.com" <u27092@uwe wrote in message
news:66de30b9a3e6f@uwe...
I have tried writing a macro that would let me capture the date from my
computer and place it in cell D2. The captured day will be moved intact
at
the end of the day

Is there a command that will let me do that?

Thanks for the help in advance.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200609/1

=today() puts the current date as taken from your PC !
=now() is the same plus the time

Steve

On Tue, 26 Sep 2006 13:39:45 +0100, Larry Fish via OfficeKB.com
<u27092@uwe wrote:

I have tried writing a macro that would let me capture the date from my
computer and place it in cell D2. The captured day will be moved intact
at
the end of the day

Is there a command that will let me do that?

Thanks for the help in advance.

The TODAY() and NOW() functions are volatile and will constantly
update. If you want the date to stick just hit ctrl+; for the date only.
If you want date and time hit ctrl+; space ctrl+shift+:

If you need it automatic then have a look here

http://www.mcgimpsey.com/excel/timestamp.html

HTH
Martin