Auto update of date in a specific cell?

**spavined** · 06-25-2009, 07:38 PM

This is likely an easy one, but it's driving me bananas. I simply want to update a "Last updated" cell any time new information is added within a range of a worksheet. While I've been able to figure out (with a Google search) how to automatically date stamp a relatively referenced cell cell, I've not been able to figure out the VBA to do exactly what I hope to do. Can anyone please offer help?

Specifically, what I hope to do is have cell "D2" automatically update to the current date whenever new information is added (including edits) within the range "A4:Z200"

Any advice is appreciated, thank you in advance.
-s

**dominicb** · 06-26-2009, 03:44 AM

Good morning spavined

...and welcome to the forum!!

Originally Posted by spavined

Specifically, what I hope to do is have cell "D2" automatically update to the current date whenever new information is added (including edits) within the range "A4:Z200"

Something like this should do the trick. It needs to go into the specific sheet module - not a regular module.

Please Login or Register  to view this content.

HTH

DominicB

**sathyakamaraj** · 07-07-2009, 01:52 PM

Originally Posted by dominicb

Good morning spavined

...and welcome to the forum!!

Something like this should do the trick. It needs to go into the specific sheet module - not a regular module.

Please Login or Register  to view this content.

HTH

I am new to this macro..
Your Code just worked great...thanks...

Auto update of date in a specific cell?

LinkBack

Thread Tools

Rate This Thread

Display

Auto update of date in a specific cell?

Re: Auto update of date in a specific cell?

Re: Auto update of date in a specific cell?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions