time stamp
Posted by Mike on June 29, 2000 4:58 PM
Is there a formula and/or function to place a time stamp in a cell that will not change? Also, VBA code would be acceptable. Any help will be appreciated.
Posted by mike on July 07, 0100 11:30 AM
Ryan,
Thanks for the help,
Mike
Posted by Ryan on June 29, 0100 5:45 PM
Mike,
If you enter a formula, it will change. You can use this VBA though:
ActiveCell.Value = Date <-- Will enter mm/dd/yy
ActiveCell.Value = Format(Now(),"hh:mm") <-- 09:10
ActiveCell.Value = Format(Now(),"mm/dd/yyyy")
Try these. If you need some more help, let me know.
Ryan
