If you are inserting a formula, it will always update when a
calculation is performed. To insert a static date, one that will
not change, use code like
ActiveCell.Value = Now
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"VW_Dick"
wrote in message
...
Ive set up a macro assigned to a button that inserts the date
into the
selected cell via the date function and then moves cursor one
column to
the right. When the date is inserted the cursor moves to cell
to the
right just fine.
The problem is that when I use the macro to insert the date and
time
into another cell at a later time or date, all of the other
dates
change to the most recent one.
Am i cra-z or should this not happen?
Thanks
--
VW_Dick
------------------------------------------------------------------------
VW_Dick's Profile:
http://www.excelforum.com/member.php...o&userid=26847
View this thread:
http://www.excelforum.com/showthread...hreadid=400898