Date Cell last updated

Originally Posted by Sparrow

Is there a way of displaying in another cell the date a cell was last updated?

Cheers

Hi,

Yes, but you need some VB code triggered by a Worksheet_Change event.

Is this for a single cell, a column, or a range of cells?

---

Originally Posted by Sparrow

It would be for a column , but i would want to know the date of each cell in the column. I would expect there to be around 200-600 cells in the column that i would require this

cheers

Hi,

ok - on the required sheet, rightmouse the tab and select View Code, paste the code there.

Please Login or Register  to view this content.

When you amend column A then B will be date-time stamped.

if you see #### in B then widen the column.

Let me know how you go
---

Originally Posted by Sparrow

Bryan
I've had a quick play with this and it seems like exactly what i needed.

Thanks
S

Hi,
Good to see that it works for you, and thanks for the response.

---
btw, the 'Reset' code will reset the 'Events' option if the code should abort for any reason (and then appear to stop working because Events = False). You can run 'Reset' any time, it harms nothing.
---