Automatic Date Macro

tmgresham

New Member
Joined
Jul 14, 2005
Messages
16
Hello,

I'd like to write a macro where the current date will be obtained from windows settings and automatically appear in a cell when the worksheet is opened.

Thanks

Tim.
 

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,275
Tim

Do you really need a macro for this?

Can't you just put this formula in a cell?

=TODAY()
 

Datsmart

Well-known Member
Joined
Jun 19, 2003
Messages
7,985
Put the following formula in the cell you want the date:
=TODAY()
 

Forum statistics

Threads
1,078,077
Messages
5,338,059
Members
399,201
Latest member
PCMK99

Some videos you may like

This Week's Hot Topics

Top