timestamp row

[Randy]

I want Column A to auto time stamp the current time
whenever column B on the same row is changed...

For column A's formula I tried "=IF (ISBLANK(B2), "", NOW
()) but that resets each row where column B is not blank
for any row modified. So then I tried "=IF (ISBLANK
(B1), "", IF(ISBLANK(A1), NOW(), "")) and set iteration to
1 to get around the circular reference, but it still
resets all rows where B is not blank to the current time.
I'm using outlook 2000.

 

[Frank Kabel]

Hi
you'll need VBA for this. See
http://www.mcgimpsey.com/excel/timestamp.html

 

[tommyboy]

What if the cell is the result of a formula, the vb code doesnt wor

 

[JE McGimpsey]

Change the event macro from the Worksheet_Change to Worksheet_Calculate,
and keep a static or global variable with the cells' value. If it
changed, update the timestamp and save the new value in the variable.

There are some examples in the archives:

http://groups.google.com/advanced_group_search?q=group:*excel*