styl3zkp

Hi there,

I just have a quick question regarding date & time stamp in Excel..

Let's say I want to make a cell dedicated to track the date and time a macro was run. For example, If I ran a certain Macro today, right now - it would say

2/2/2009 11:42 (but the data is actually 2/2/2009 11:42:08 AM)

I want to write Macro so that it would keep track of this date and time. If However I realize I can't use DATE() or NOW() since it will always use the actual date and time and Not the date and time the macro was last ran.

Is there any way to track or record the date and time Macros are run?
Is that even possible?

Thanks in advance for your time and help!
-styl3zkp

Elkar

Just add this line into your Macro code:

Range("A1").Value = Now()

Change A1 to whatever cell you want to place the date in. This way, cell A1 will only update when the macro is run, and will display the current date/time that the macro was last run.

HTH
Elkar