If you need to generate a time-stamp automatically in a spreadsheet (to tell when the last time a macro was run, for example) and you don’t know VBA or are intimidated by it, you can use the macro recorder. Keep in mind that if you use the standard functions:
=today() or =now()
as you record, they will be accurate- temporarily, but the formulas will update as the time changes, giving the wrong time stamps.
A solution is simple: creat a macro that copies the date/time and then use paste special to paste the value only. The pasted value will not update.
Jared Hawk is a professional Microsoft Excel Seminar Trainer and Consultant in Boise, ID. He is also a contributing author to www.masterthebusiness.com and idahocle.com