Simple VBA Code for Designated Column Time Stamp (updates when amending Cell in the Row)

[MaddenJMF]

Hi all!

I'm new here, I'm hoping you can help with my little problem.

Please Login or Register  to view this content.

Simply adds a timestamp to column U when any value is edited in range A through T.

Problem is, it detects "deleting a row" as action taken, and leaves the time value in cell below (thats now moved up since the row above was deleted).

This now does not help me achieve my goal of having the time updated when a row is amended. Its adding the updated time to the entry below, which was never amended.

Is there a way I can add a condition where the time is not added when the row is deleted?

I have screenshots but attachments button is not working for me.

[Norie]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[TMS]

Maybe:

Please Login or Register  to view this content.

[MaddenJMF]

Maybe:

Please Login or Register  to view this content.

This worked perfectly, thanks a lot!

This also prevents the time from populating when a new row is added. But this is actually better than my initial idea.

As you probably know, this can happen a lot in Excel!

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.